CICA 1994 April/CICA Shareware for Windows CD-ROM (Walnut Creek CD-ROM)(April 1994).ISO/win3/access/access_l.exe/ACC9310.TXT

Text File | 1994-01-07 | 181KB | 4,093 lines

=========================================================================
Date:         Fri, 1 Oct 1993 11:10:30 +0000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Martin Ederveen <[e-mail]>
Organization: Hogeschool Eindhoven
Subject:      Evaluating version 1.1 and SDK

Hiya all.

I've been using the version 1.1 for about two months now (we didn't
get the update faster here in Europe).
Some things do not work as they should:

- Somehow the standard Windows screensavers mess up with Access. For
instance when compressing the database (or repairing) the whole lot
'hangs' when the screensaver kicked in. Sometimes the pictures don't
get restored (or wrong) in an application after a saver kicked in.

- An application of mine running on a (yes, slow) 386SX 4 MB RAM IBM
when creating Print-Preview (with graphics) just jumps out of this
without any error-messages (probably not enough memory); version 1.0
just crashed Windows at this point. This is resulting in the end-user
cannot use the print- facilities in the application I designed for
them.

- Using an '=Reference to subform hidden field' in a formfield source-
line just shows the right value but doesn't UPDATE that field with
the value. I used the format =[subform].Form![field]. Looks like it's
just display-only, is this correct?

- The SDK wizard doesn't work? Every time I start it and fill the
data, it always finishes with the error it cannot open the database.
What am I doing wrong? You can assume I typed the path and name
correct, of course  ;)

- Why didn't MicroSoft make an SDK wich COMPILES the source? Keep on
interpreting the data and it's guarantee slow-boat. This was not what
I expected of a runtime application.

- And also why does it pack all the databasefiles into one large HUGE
file? Why not put at least the tables, forms, queries and such into
separate files? Yes, I know they advised using separation from data
and forms by some method, but flexibility isn't in that method (page
11 of distribution kit guide).

- Why didn't version 1.1 get an expansion of the Form and more urgent
the Report Wizard options? I miss several nice features and choices
built in, like being able to decide wich data gets on one page and
how it's separated.

Well, that's all for now, maybe some discussion will start on this?
----------------------------------------------------------------------
| ing. Martin W. Ederveen    | "In the future there will be real     |
| Hogeschool Eindhoven       |  thinking machines.                   |
| Postbus 347                |  Yes, but who's thoughts will they    |
| 5600 AH Eindhoven          |  be thinking?"                        |
| tel. [phone]      |                                       |
| fax. [phone]      |  Quotation from Dr.Who:               |
| Email [e-mail] |   The Curse of Fenrick                |
=========================================================================
Date:         Fri, 1 Oct 1993 10:41:00 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Long <mvgsd![e-mail]>
Subject:      Validation Rule Overide?

I have a text field on a form in which
I apply a DLast function as the default. I increment the
default by 1.
I have a validation rule for that same field equal <30.
If I directly enter 30 into the field the validation rule works.
If the function enters the 30 by default the validation rule
doesn't work. Is this normal?
==============================================================================
  David B. Long                             E-Mail=> [e-mail]
  AT&T Network Systems (N.Andover MA.)      or=> [e-mail]
  Quality Engineering                       Tele=> 508-960-3683
==============================================================================
=========================================================================
Date:         Sun, 3 Oct 1993 13:58:04 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Linda D. Cornell" <[e-mail]>
Subject:      Need help with getting a report working

Hi there,
We're kind of confused.  We want to run a report that has the following
output in columns:


Group Name     #This Month     $This Month      #Year to Date    $Year to Date



The problem that we have is if we select only this months records, how
can we reselect and get the rest of the records for the year to date
totals (or vice versa)?

Can you do something in SQL like:

Select records from master_file for 1993 and call them Year_to_Date and
Select records from master_file for September and call them Monthly.

We've been poking around at this and we have tried subforms, etc. but the
light of enlightenment has not yet turned on!

Maybe it's something like building a second table of just Year to Date
records and then skimming the September records for the first column or ????

Help!

Thanks in advance!

Linda Cornell
[e-mail]
=========================================================================
Date:         Sun, 3 Oct 1993 22:51:38 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Need help with getting a report working
In-Reply-To:  <[e-mail]> from "Linda D. Cornell" at Oct
              3, 93 01:58:04 pm

Linda,

I have encountered a similar problem building reports.  I solved it by
building a table that holds nothing but the rows for my report.  To
build the report I go throught the following sequence:

1) Delete all rows in the reporting table.

2) Extract the month to date, in my case, last pay period data, and
   write it to the reporting table.

3) Extract the year to date data, and write it to the reporting table.

4) Fire up the report, using the reporting table as the record source.

Hope this helps.

John
[e-mail]
Woodinville, WA
=========================================================================
Date:         Mon, 4 Oct 1993 15:16:00 WST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         780940 <[e-mail]>
Subject:      ODBC Drivers for Access 1.0 or 1.1

Hi Access lovers!

 I don't known if this question has been asked before. Our company is going to
develop a project using MS Access as the database engine , also this project
would support the ODBC standard. I would like to that whether Microsoft has
release the ODBC Drivers for Access 1.0 or 1.1.

 Any information will be appreciated.
 Thanks!

Best Regards!

Guss Hsu
=========================================================================
Date:         Mon, 4 Oct 1993 14:47:00 MET
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Marie Fors <[e-mail]>
Subject:      Change mouse pointer!

               Hello!

I wonder if there is anybody who can help me with a problem. I know that
this can be solved by using windows API, but maybe somebody already has got
the solution and would like to share it with me.

The problem is that I would like to change the mouse pointer to a hand, when
it is over a button.

Regards from Marie Fors
[e-mail]
=========================================================================
Date:         Mon, 4 Oct 1993 14:35:28 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Steve Bratten <[e-mail]>
Subject:      Formatting numbers in calculated fields in a query...

Is there a way to limit the number of decimal places in a number that is
a calculated field in a query? If so, how?

Thanks

Steve B. < [e-mail] >
=========================================================================
Date:         Mon, 4 Oct 1993 18:18:15 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Formatting numbers in calculated fields in a query...

% Is there a way to limit the number of decimal places in a number that is
% a calculated field in a query? If so, how?

Specify a field on the fly (fieldname followed by a colon, followed by the
 calcuation)

Two easy options (choose the one appealing to you)

1) Use the Format function and create a formatting mask.
2) The old, old programmer's trick (predating format functions) of multiplying
 by 10**accuracy, clipping the
decimal point, then dividing by 10**accuracy, where <accuracy> is the number of
 decimal places.
=========================================================================
Date:         Mon, 4 Oct 1993 19:29:09 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Finley <[e-mail]>
Subject:      Re: Formatting numbers in calculated fields in a query...
In-Reply-To:  <[e-mail]> from "Steve Bratten" at Oct 4,
              93 02:35:28 pm

>
> Is there a way to limit the number of decimal places in a number that is
> a calculated field in a query? If so, how?
>
> Thanks
>
> Steve B. < [e-mail] >

You can use the format command. Also, a function built for this purpose is
described in the MS-Access knowledge base.

Dave F.

--
=========================================================================
Date:         Tue, 5 Oct 1993 09:16:03 SAT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Organization: King Fahd University of Petroleum and Minerals, S.A.
Subject:      subscribtion

hell all
I have tried many times to subscribe to that list ..and I sent ok confirmation
to listserv at indycms ...and It is still failed ...please tell how to subscrib
e?
e-mail to [e-mail]
thanx
=========================================================================
Date:         Tue, 5 Oct 1993 10:28:29 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dave Finley <[e-mail]>
Subject:      Access versus FoxPro

In adopting Access in our shop, we've continually run into the issue of
"Access" versus "Foxpro". This especially comes up when discussing "speed".
>From what I've seen, Foxpro for Windows may be faster at runtime,
especially for large data-tables. But Access provides much faster
development (less coding is required). Also, Access seems to works more
closely with Windows.

I would like to get other people's thinking on this issue. Has anyone else
run into this controversy? What do they think of it? Which (Access or
FoxPro) is the better development platform? Why?
=========================================================================
Date:         Tue, 5 Oct 1993 10:52:26 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: subscribtion
In-Reply-To:  Message of Tue, 5 Oct 1993 09:16:03 SAT from <STUP9E9@SAUPM00>

I'd be glad to add you manually but I need your name to go along with
your user id to do so.  If you would give me that, I'll sign you right
up.

Nathan Brindle
Listowner, Access-L

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Tue, 5 Oct 1993 10:53:34 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: subscribtion
In-Reply-To:  Message of Tue, 5 Oct 1993 09:16:03 SAT from <STUP9E9@SAUPM00>

Sorry, that was dumb...not awake yet this morning...:)

Nathan

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Tue, 5 Oct 1993 11:38:41 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Steve Bratten <[e-mail]>
Subject:      Calculated field formatting solved; a great list here...

>You can use the format command....
>Dave F.

>1) Use the Format function and create a formatting mask.
>Phil Paxton

Thanks to each of you for providing me with the answer to my
question -- how to format a CALCULATED FIELD in a query. I did
spend a short time scratching my head before I figured out that
the mask needs to be enclosed in quotations; I didn't get that
from the online help for the FORMAT FUNCTION until I looked at
the linked example.

BTW, I've been using Access for a few months now but have just
begun utilizing some Access Basic. A long-time pascal programmer,
I'm looking forward to getting in on some of the more BASIC
discussions I see here. I do like the event-driven programming
idea and have some experience there from using a Pascal-Code
generator called Turbo Magic by Sophisticated Software; anyone
heard of it?

Thanks again; this is a superb discussion group.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|                         o__                                          |
| Steve Bratten          _.>/^_      BITNET < GE0793@SIUCVMB >         |
| Graduate School       (_) \(_)   INTERNET < [e-mail] > |
| Southern Illinois University                                         |
| Carbondale IL 62901-4716   \o  \o  \o   Graduate School              |
| Voice: [phone]       |>  |>  |>  Southern Illinois University |
|   Fax: [phone]      < \ < \ < \  Carbondale, IL  62901-4716   |
|                                                                      |
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^Steve Bratten^^^^^^^^^
=========================================================================
Date:         Tue, 5 Oct 1993 12:43:14 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Hank Wolf <[e-mail]>
Subject:      Re: Access versus FoxPro
In-Reply-To:  <[e-mail]> from "Dave Finley" at
              Oct 5, 93 10:28:29 am

I would be interested in comments comparing Access to Paradox, as well.
Are the image handling capabilities comparable?

Thanx. Hank
>
> In adopting Access in our shop, we've continually run into the issue of
> "Access" versus "Foxpro". This especially comes up when discussing "speed".
> >From what I've seen, Foxpro for Windows may be faster at runtime,
> especially for large data-tables. But Access provides much faster
> development (less coding is required). Also, Access seems to works more
> closely with Windows.
>
> I would like to get other people's thinking on this issue. Has anyone else
> run into this controversy? What do they think of it? Which (Access or
> FoxPro) is the better development platform? Why?
>
=========================================================================
Date:         Tue, 5 Oct 1993 12:14:00 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Ellington, Robert W (Bob)" <[e-mail]>
Subject:      Determine inactivity?

I would like to be able to determine from inside my App that there has been
Xminutes inactivity, and then when a user starts to use the app again I can
pop up a login/password screen.  Does anybody have any idea how to determine
that the system has been inactive for a length of time?

Any help appreciated
Bob Ellington
[e-mail]
=========================================================================
Date:         Tue, 5 Oct 1993 12:59:25 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Joe Svitak <[e-mail]>
Subject:      Re: subscribtion
In-Reply-To:  Message of Tue, 5 Oct 1993 09:16:03 SAT from <STUP9E9@SAUPM00>

     I checked your node on the list of Bitnet nodes and it said you are
running on a VM system.  You can type the following command and it should
subscribe you to Access-L list:

          Tell Listserv at INDYCMS sub Access-L <your name>

where you put your name in place of <your name>.  If this doesn't work
then send a message to Listserv@Indycms with the following line contained
in the body of the message:

          Subscribe Access-L <your name>

where you put your name in place of <your name>.

     Either way you should get one or two messages back from listserv@indycms
saying that you subscribed to the list.  Good luck.

Joe Svitak

The Graduate School and University Center
of the City University of New York

Bitnet address: [e-mail]
Internet address: [e-mail]
=========================================================================
Date:         Tue, 5 Oct 1993 14:12:55 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: subscribtion
In-Reply-To:  Message of Tue, 5 Oct 1993 12:59:25 EDT from <JJSGC@CUNYVM>

Just so all know:  The answer posted to the list is right as far as it
goes, but the subscriber was having trouble posting the subscription
confirmation <back> to the listserver <after> he had already sent the
subscription request.  When ACCESS-L first was started, I did not have
that function set (in fact, it was not available until LISTSERV version
1.7f came out) so some of you who subscribed when the list was young may
not have encountered that.

(Also, since he isn't subscribed to the list, he isn't going to get that
piece of mail...)

Just FYI,
-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Tue, 5 Oct 1993 17:35:57 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Determine inactivity?

% I would like to be able to determine from inside my App that there has been
% Xminutes inactivity, and then when a user starts to use the app again I can
% pop up a login/password screen.  Does anybody have any idea how to determine
% that the system has been inactive for a length of time?

Why not write a screensaver which does this and then use the Windows API calls
 to designate this
screensaver when your application loads?
=========================================================================
Date:         Wed, 6 Oct 1993 11:30:00 +1000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Kevin Anderson <[e-mail]>
Subject:      Re: Access versus FoxPro

I am doing a similar exercise. If you could pass on any comments to me
I would greatly appreciate it.

What is Microsoft's long term plan? Will Access and Foxpro become the
one product?

Kevin Anderson
"[e-mail]"
=========================================================================
Date:         Thu, 7 Oct 1993 04:08:42 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Determine inactivity?
In-Reply-To:  <[e-mail]> from "Phil Paxton" at Oct 5,
              93 05:35:57 pm

>
> % I would like to be able to determine from inside my App that there has been
> % Xminutes inactivity, and then when a user starts to use the app again I can
> % pop up a login/password screen.  Does anybody have any idea how to determine
> % that the system has been inactive for a length of time?
>
> Why not write a screensaver which does this and then use the Windows API calls
>  to designate this
> screensaver when your application loads?
>

Their is a timer DLL, and an associated sample program that is available
in the Microsoft Access forum on Compuserve in the Access BASIC section.
Find a friend who has Compuserve and have them download it for you.
It's self explanatory.

John
[e-mail]
=========================================================================
Date:         Thu, 7 Oct 1993 16:42:27 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Thomas G. Durand" <[e-mail]>
Subject:      Re: subscribe to access-l@indycms Eric Laverdiere

 [A
=========================================================================
Date:         Fri, 8 Oct 1993 07:49:36 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Scott Dahne <[e-mail]>
Subject:      Re[2]: Access versus FoxPro

     I agree that Fox is faster but Access is better for quick development
     work.  I use both systems in the following way when working with large
     databases (50-100MB): Do all database work in Fox to include indices
     and then write the interface in Access and attach out to the Fox
     files.  Works great and the databases can also be used by other
     platforms if necessary.

     With regards to Paradox for Windows, we had so many development
     problems and system crashes that Borland couldn't solve that we gave
     up on it and switched to the above sceario for future projects.  If MS
     puts the Fox engine in Access, it will be unbeatable.


     Scott Dahne
     Research Fellow
     Logistics Management Institute
     [e-mail]


______________________________ Reply Separator _________________________________
Subject: Re: Access versus FoxPro
Author:  Microsoft Access Database Discussion List
<[e-mail]> at INTERNET
Date:    10/5/93 4:03 PM


I would be interested in comments comparing Access to Paradox, as well.
Are the image handling capabilities comparable?

Thanx. Hank
>
> In adopting Access in our shop, we've continually run into the issue of
> "Access" versus "Foxpro". This especially comes up when discussing "speed".
> >From what I've seen, Foxpro for Windows may be faster at runtime,
> especially for large data-tables. But Access provides much faster
> development (less coding is required). Also, Access seems to works more
> closely with Windows.
>
> I would like to get other people's thinking on this issue. Has anyone else
> run into this controversy? What do they think of it? Which (Access or
> FoxPro) is the better development platform? Why?
>
=========================================================================
Date:         Fri, 8 Oct 1993 13:53:00 +01
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Nilsson Jimmy, HK/R IDE" <[e-mail]>
Subject:      Access/Paradox?

Hi!
 ----

I have some friends who I try to convince that Access is better than
Paradox. Can anybody help me with some arguments?

Thanx!
Jimmy Nilsson, Universty of Karlskrona/Ronneby
###
=========================================================================
Date:         Fri, 8 Oct 1993 09:20:07 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Mark T Wignall <[e-mail]>
Subject:      New User/List Member :)

Hello Any/All!

Im BRAND SPANKING NEW to bitnet, and thus this 'LIST'.

I'm eager to learn/share infor regarding MS Access.  Well
at any rate, I just wanted to say hi to you all.  Time for
me to get back to ACCESS!

Sincerely,
Mark Wignall
=========================================================================
Date:         Mon, 11 Oct 1993 05:48:10 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Stephen Hueners <[e-mail]>
Subject:      ? using Access for LIST msg management

Is anyone using ACCESS to manage thier internet activity i.e. lists and/or
news groups?

I've been told there is a file called DIAL on CI$ that allows ACCESS to dial
a number based on the contents of a field? Anyone know where it (or
something like it) is available ftp?

Is there a Visual Basic-specific list?

Thankx much
--steve...
=========================================================================
Date:         Mon, 11 Oct 1993 09:57:57 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      using Access for LIST msg management

% Is anyone using ACCESS to manage thier internet activity i.e. lists and/or
% news groups?

I'm not current on all of this, but Microsoft did provide a rather cheezy Access
 application for organizing
captured Compu$erve messages -- you turn on the screen capture, list the
 messages, then run them through
the application and it formats them appropriately.  The messages aren't too
 different but what the
application couldn't be adapted for Usenet or LISTSERV.

% I've been told there is a file called DIAL on CI$ that allows ACCESS to dial
% a number based on the contents of a field? Anyone know where it (or
% something like it) is available ftp?

Just a "file" ? :)  There are now several Access (it's not an acronym)
 applications for dialing.  Perhaps the
best known is one written by Roger Jennings who details his in his book "Access
 1.1 Developer's Guide".

% Is there a Visual Basic-specific list?

Yes. There are VB lists in the Internet domain, LISTSERVs, and Usenet groups.
=========================================================================
Date:         Mon, 11 Oct 1993 19:01:00 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Karlsson, Mats" <[e-mail]>

REGISTER Mats Karlsson, Communicator Teleplan AB, Sweden
SUBSCRIBE ACCESS-L
=========================================================================
Date:         Mon, 11 Oct 1993 19:02:00 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Karlsson, Mats" <[e-mail]>

REGISTER Mats Karlsson, Communicator Teleplan AB, Sweden
SUBSCRIBE WORD-PC
=========================================================================
Date:         Mon, 11 Oct 1993 11:56:24 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: Access versus FoxPro
In-Reply-To:  <[e-mail]>; from "Dave Finley" at Oct
              5, 93 10:28 am

>In adopting Access in our shop, we've continually run into the issue of
>"Access" versus "Foxpro". This especially comes up when discussing "speed".
>From what I've seen, Foxpro for Windows may be faster at runtime,
>especially for large data-tables. But Access provides much faster
>development (less coding is required). Also, Access seems to works more
>closely with Windows.
>
>I would like to get other people's thinking on this issue. Has anyone else
>run into this controversy? What do they think of it? Which (Access or
>FoxPro) is the better development platform? Why?

Quick observations (I have used both):

SPEED: FoxPro is faster, but Access 2.0 is supposed to have the same query
technology, so this advantage should go away.

EASE OF USE: Access is far easier to use.

DEVELOPMENT: While the development environment is "easier" in Access, FoxPro's
is far more sophisticated and powerful.

LANGUAGE: Given that, for real application development, one has to use a
quirky combination of macros and Basic, and deal with many bugs ("features")
and workarounds, I think Access's "simple" language structure is actually
a liability. The xBase standard which FoxPro uses is much more
straighforward for working with tables and such. I found the paradigms
with each of these products, concerning where to use code and such, were
difficult to get used to for a while.

CAPABILITY: FoxPro is much more well-rounded, but there are certainly also
things which Access does which are more difficult to do in FoxPro. Access
doesn't have enough features or customizability to lend to true application
development, even though many (including myself) push it to its limits and
use it for this purpose.

>Are the image handling capabilities comparable?

I ended up working with Access exclusively for the last few months, so haven't
touched FoxPro in a while, but I believe it does lack any kind of image
data type. Access does have this feature, but I find it limited. It should
accept more types of images.

>What is Microsoft's long term plan? Will Access and Foxpro become the
>one product?

Sort of. I saw Bill Gates speak on this at DB-EXPO`93. Like I said, much
of the back-end technology in Fox-Pro should be in the next release of
Access (it makes sense, really). But, in the end, it does look like Fox-Pro
is primarily going to be used to provide an eventual path for dBase users
to go with something more object-oriented. Ultimately, as Mr. Gates
explained, Microsoft would like to separate out all the components, those
being the development tools (GUI builders, etc.), language, and database
engine. He held up xBase (Foxpro), C++ and Visual Basic as the three
languages he would like to see available for any of their products. Then,
for database engines there are Access, dBase, and of course SQL Server.
Applications or development environments range from those that are currently
in Visual Basic, Access and FoxPro to Word, Excel and so on. The idea is,
then, to pick and choose your components based on your taste, and yet still
get the best possible performance and capability.

What does this mean? Doesn't look like using either Access or FoxPro
(or Visual Basic) will lock you out of any kind of future upgrade paths.
So, the moral is, use whatever works. I could make cases for any of the
products, depending upon the application.

--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Mon, 11 Oct 1993 19:07:30 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Bill Stewart <[e-mail]>
Subject:      Access Tip!

I just found a way to bypass the confirmation dialogue box when deleting a
database object.

Just select the object to delete(table, query, macro, etc..) then hold down
the shift key and press delete.

------------------------------------------------------
Bill Stewart
Gendale Community College
6000 W. Olive Ave
Glendale AZ. 85302
------------------------------------------------------
=========================================================================
Date:         Tue, 12 Oct 1993 14:32:23 GMT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Paul Snell <[e-mail]>
Subject:      Importing delimited text into Access

I am sending this message on behalf of a colleague.

He is trying to import a delimitted file from a main-frame
database into Access.  Each record takes up 16 lines in the
source file that he receives from the main-frame people.  When
Access imports this data it is interpreting each line as a
single record.  Hence each record has been split up into 16
separate records!

After some fiddling he found that if he could get each record in
the source file onto one line then Access would correctly import
the file.

What he would like to know is, is there a smart way to strip out
the unwanted carriage returns for each of the 16 lines - there
are several hundred records in the source file (each with some
280 fields.)

Any thoughts welcome

Many thanks

Paul

*****************************************************************
***                                                           ***
***  From:  Paul Snell      Email: [e-mail]       ***
***         IT Trainer                                        ***
***         ACS IT Training Centre                            ***
***         University of Birmingham                          ***
***         B15 2TT                                           ***
***         UK                                                ***
***                                                           ***
***         Tel: [phone]   Fax: [phone]             ***
***                                                           ***
*****************************************************************
=========================================================================
Date:         Wed, 13 Oct 1993 07:16:18 CDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Heath Wells <[e-mail]>
Subject:      mailing

Please include me on the Access mailing list. I am interested in the old
messages.
=========================================================================
Date:         Wed, 13 Oct 1993 08:14:44 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: mailing
In-Reply-To:  Message of Wed,
              13 Oct 1993 07:16:18 CDT from <[e-mail].U IUC.EDU>

In general, LISTSERV does not require that the List Owner subscribe you
to a list.  You may self-subscribe by sending mail to LISTSERV@INDYCMS
(Bitner) or [e-mail] (Internet) with the command

SUB ACCESS-L <Your Name>

as the body of the message.  If you are unfamiliar with LISTSERV and its
associated commands, I suggest that you add the commands

INFO GENINTRO
INFO REFCARD

as additional lines of your message.  LISTSERV will then send you file s
containing a General Introduction to Revised LISTSERV that will give
you some instruction on the service and a Quick Reference Card of the
various commands.

Thanks for your interest.  If you have trouble subscribing with this
method, please let me know and I will attempt to help.  Because LISTSERV
now includes a method of verifying mailing paths for new subscribers
which is not implemented when the list administrator adds people to
the list, it is preferred that users subscribe themselves by the method
outlined above.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 13 Oct 1993 08:17:20 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      oops

I think I'm going to quit doing list maintenance in the morning...

Sorry about that last post, I forgot the REPLY FROM.

Nathan

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Thu, 14 Oct 1993 15:26:27 GMT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Paul Snell <[e-mail]>
Subject:      Version 2.0 ?? Dates..Features

Sorry if this is a repeated request - I might have missed
earlier discussions.

Can anyone say WHEN version 2.0 might be released and if you
have any ideas as to the advantages it would have over 1.1?

(Guess who is thinking of buying Access for a cluster of
machines!)

Thanks

Paul

*****************************************************************
***                                                           ***
***  From:  Paul Snell      Email: [e-mail]       ***
***         IT Trainer                                        ***
***         ACS IT Training Centre                            ***
***         University of Birmingham                          ***
***         B15 2TT                                           ***
***         UK                                                ***
***                                                           ***
***         Tel: [phone]   Fax: [phone]             ***
***                                                           ***
*****************************************************************
=========================================================================
Date:         Thu, 14 Oct 1993 15:56:00 EET
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Petteri Karna <[e-mail]>
Organization: University of Helsinki
Subject:      (S)VGA,no results returned in query,null values in index

Hello to all Access users,

I am developing a document management application with Access 1.1 &
ADK. I would appreciate if anyone of you could help me in the
following problems:

1. How can check if the user is running the application in VGA/SVGA
mode ? I would like to fit the size of forms accordingly.

2. Is there a way to check if a query returns no results ? Now the
user sees #Error strings on the report if no results returned. The
underlying query is somewhat tricky. It has several joins, some of
the expressions use IIF function, and one field is only used for
criteria, it does not show up on the report. May be I should post
the query in detail...

3. Some forms are only used for data entry. If the user does not enter
a value in the primary key field, the system will give a warning.
I wrote some AB code to check for Null values, but the system keeps
on giving warnings. Is there a way to avoid these system warnings ?

Any hints appreciated,

Petteri Karna      [e-mail]
=========================================================================
Date:         Thu, 14 Oct 1993 11:29:01 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jim Renaud <[e-mail]>
Subject:      Re: (S)VGA,no results returned in query,null values in index

I had some trouble recently where a report (based on a query) did
not return any records and some AB code that was checking a control
in the report died with the following error:

        Internal Database Error (-1603).

I never was able to figure out what this meant, but I did put
some AB code that checks when opening the report if the query
has record count is < 1. If so, I just display a message and
close the report. The nasty thing about the "Internal Database Error"
is that I get that when accessing the variable (defined as variant)
whether in inline code or just typing in the immediate window.

Anyway, you can probably get around your problem by checking the
count of records returned by the query like I did.

>
> 2. Is there a way to check if a query returns no results ? Now the
> user sees #Error strings on the report if no results returned. The
> underlying query is somewhat tricky. It has several joins, some of
> the expressions use IIF function, and one field is only used for
> criteria, it does not show up on the report. May be I should post
> the query in detail...
>


-----------------------------------------------------------------------

Jim Renaud                              [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 235                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470
=========================================================================
Date:         Fri, 15 Oct 1993 14:46:10 EET
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Petteri Karna <[e-mail]>
Organization: University of Helsinki
Subject:      version 2.0

There was an article about pre-beta features for version 2.0 in PC
Week:
- table wizard for novice users, ER-model designer ?
- OLE2 support (client-side?)
- support for right mouse button to access menus

I think the emphasis is to better support the novice user. I don't
remember the rest of the new features, but it was scheduled
to be out Dec '93 - early next year.

Petteri Karna
[e-mail]
=========================================================================
Date:         Fri, 15 Oct 1993 08:48:50 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Rob Riopelle BIS,CRL @3499" <[e-mail]>
Subject:      MS-Access and Pathworks 4.1

Hello Access Users,

I am not sure if this should be sent to the ORACLE list or not but it
doesn't seem to be an ORACLE problem.

We have Pathworks 4.1 and I am trying to access an ORACLE database on the
VAX mainframe through SQL*Net and the MS ODBC driver for ORACLE. SQL*Net
works find when I use SQL*Plus for windows from my PC.

When I use MS-Access 1.1 and try to import an ORACLE table I get the ORACLE
error message ORA-3112 host string syntax error. Everything also seemed to work
fine from MS-Access using SQL*Net when we had Pathworks 4.0.

Any suggesttions would be greatly appreciated.

===============================================================================
Rob Riopelle
Programmer/Analyst
AECL Research                               Internet: [e-mail]
Chalk River, Ontario, Canada                  Bitnet: [e-mail]
"Any opinions expressed are my own"
===============================================================================
=========================================================================
Date:         Fri, 15 Oct 1993 17:13:29 SAT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Sam Somuah <[e-mail]>
Organization: King Fahd University of Petroleum and Minerals, S.A.
Subject:      FTP Sites for Access Shareware

Does Anyone know of FTP sites for Access shareware
Any help will be greatly appreciated

Sam Somua <RSIV95K@SAUPM00>
=========================================================================
Date:         Fri, 15 Oct 1993 12:04:52 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      FTP Sites for Access Shareware

% Does Anyone know of FTP sites for Access shareware
% Any help will be greatly appreciated

% Sam Somua <RSIV95K@SAUPM00>
                                       -------------
???



Have you tried CICA?  There's some there.  I haven't had Archie search in
 awhile, but there
are probably some other sites by now.  Also, Compu$erve has a pretty rich
 inventory of
applications...

phil paxton
development editor
sams / prentice hall computer publishing                  (<=== GO PHCP)
paramount publishing
indianapolis, indiana
=========================================================================
Date:         Fri, 15 Oct 1993 14:40:15 -0500
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Michael J. McNaughton" <[e-mail]>
Subject:      Re: FTP Sites for Access Shareware

On Fri, 15 Oct 1993 17:13:29 SAT, Sam Somuah wrote:

>Does Anyone know of FTP sites for Access shareware
>Any help will be greatly appreciated
>
>Sam Somua <RSIV95K@SAUPM00>

You may want to check ftp.cica.indiana.edu or ftp.microsoft.com.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Michael J. McNaughton
University of Minnesota - Office of Human Resources/Employee Benefits
Suite 210 - 1313 5th St SE - Minneapolis, MN 55414-4505 USA
Voice 612-627-1070   Fax [phone] Internet [e-mail]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
=========================================================================
Date:         Sat, 16 Oct 1993 21:15:15 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: (S)VGA,no results returned in query,null values in index
In-Reply-To:  <[e-mail]> from "Petteri Karna" at Oct 14,
              93 03:56:00 pm

1)  There is a function in the NWIND database that can be used to check
for the presence of a VGA screen.  It is called by the autoexec.

2)  To find out if a query is returning records, check the recordcount
property of the resulting dynaset.

John
=========================================================================
Date:         Sat, 16 Oct 1993 21:26:24 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Oh Nathan?
In-Reply-To:  <[e-mail]> from "Nathan Brindle" at Oct
              13, 93 08:17:20 am

Nathan,

A couple of days ago I got a message saying I should forward it back to
the server to confirm my continued subscription to the Access server.
Both came back saying I was not subscribed!  If I am not subscribed, how
did I get the message in the first place?  How do I straighten this out?

John von Colditz
[e-mail]
"Puzzled in Seattle"
=========================================================================
Date:         Sat, 16 Oct 1993 23:33:18 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: Oh Nathan?
In-Reply-To:  Message of Sat,
              16 Oct 1993 21:26:24 -0700 from <johnvon@HALCYON.C OM>

The reason being (and I'm sending this to the list to forestall any other
questions) that the list has you subscribed as [e-mail]--
which could mean any number of things but they have to do with <your>
node, not anything LISTSERV is doing.  Apparently there has been a change
in your local setup wherein your domain name has changed slightly but
the old domain name still works.

The remedy is for me to unsub your old address and for you to resub from
your new address so LISTSERV can get this all straight--or for you simply
to wait for the old subscription to expire and resubscribe.

Whenever a domain name changes, you've got to unsub from lists and resub
with the new domain.  Sometimes people aren't aware that there has been a
change because they keep getting mail just like they always did as long
as the old domain keeps forwarding the mail.

If you're curious as to how LISTSERV has you signed up, send the command
QUERY ACCESS-L to [e-mail]--and if it says you aren't
subscribed, send the command REVIEW ACCESS-L to the listserver and check
the subscriber list before sending messages to me.  An informed user is
a power user, folks...

Happy Sunday!

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Sun, 17 Oct 1993 08:16:00 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      [RE:] Oh, Nathan

Nathan,
I am broadcasting this to the list because apparently I am not the only
one who has had trouble with the list.  I just did a QUERY ACCESS-L and
it says that I am not subscribed to the list.

I don't know anything about how listservers work, but I belong to many
lists and this list is somehow different.  I don't feel I have any
control - every time I have wanted to do anything other than send mail
to the list (including SUBscribing), it has not worked and you have had
to intervene.  Should I maybe UNSUB and SUB again?

Thanks,

Jim Pejsa  [e-mail]
=========================================================================
Date:         Sun, 17 Oct 1993 08:50:10 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Subscription Problems
In-Reply-To:  Message of Sun, 17 Oct 1993 08:16:00 CST from <PEJSAJ@UWSTOUT>

Again, there is a difference from the address in the header of your mail
to ACCESS-L ([e-mail]) and the address under which you are
subscribed to ACCESS-L ([e-mail]).  One is a BITNET address,
the other is an Internet address.  If you subscribe by sending mail to
[e-mail] rather than LISTSERV@INDYCMS, LISTSERV is going
to pick up your Internet address from the header because (surprise) you
subscribed via the Internet.  (Jim, since I subscribed you personally,
you're a special case.)  The point here is that LISTSERV does not always
understand that (for instance) UWSTOUT.BITNET = UWSTOUT.EDU, and that
is probably because UWSTOUT's entry in the BITEARN NODES file does not
include information on UWSTOUT's Internet alias.

There's nothing <I> can do about this (other than resub <you>, Jim) because
LISTSERV can only work with the address information it's given and what it
has in its memory and files.  BITEARN NODES is updated monthly so the problem
lies in the fact that node administrators don't provide complete information
on their site.  BTW, this is an extremely common problem among LISTSERV
people--the list owners' list is constantly getting messages about sites
that can't get through or have changed their info without telling anyone.

Now:  Can we please get this off the list and back to the normal route,
i.e., send this sort of problem directly to me and I'll see what I can
do about it?  Jim, do you want me to re-do your subscription to a BITNET
address rather than Internet?

Oh, one more thing:  When I use PMDF mail from the VAX instead of the
"regular" mailer, I get BITNET headers rather than Internet.  If you've
switched mailer software recently, this could also be part of the problem.
Thankfully I don't use the VAX much (sly grin) and stick to BITNET for
my LISTSERV subscriptions.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Sun, 17 Oct 1993 17:18:22 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      INDYCMS downtime

To users of my lists:

INDYCMS will be down on Monday, October 18 from 9:00PM - 6:00AM.  This
means that LISTSERV will also be down during that period, so don't be
surprised if you don't see mail from the list for a while...

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Tue, 19 Oct 1993 09:11:14 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dave Finley <[e-mail]>
Subject:      Excel, Word upgrades?

Has anyone heard anything about the upgrades to MS-EXCEL, MS-Word for
Windows? Does anyone know where I can obtain press releases from
Microsoft?  I have heard it rumored that they'll be announced today, but
I've not heard anything more.

This may be a little "off the subject" of Access-L. But I hope someone out
there would know.
=========================================================================
Date:         Tue, 19 Oct 1993 07:23:18 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Bill Stewart <[e-mail]>
Subject:      Re: Excel, Word upgrades?

I read about both products in the latest copy of Windows magazine.  Also
herd it should be towards December for a release date.  Cost of upgrading
each will retail $129.00

Bill Stewart
=========================================================================
Date:         Tue, 19 Oct 1993 09:27:27 -0600
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Warning -- original Sender: tag was [e-mail]
From:         "John A. Olson" <[e-mail]>
Subject:      How can I hide tables?

Hello all!

I'm trying to do something a little unusual here.  I have some tables
(attached) in my db and some queries defined.  What I would like to do is
hide the attached tables in such a way as to eliminate them from the list
when the user makes a query.  In other words, as we all know, when defining
a query, we are given a list of Tables/Queries to choose from as our
sources.  What I want to do is have this list limited to only a list of
queries to choose from.  I don't want the users to even see the table names
listed as options.  I'm trying to create a layer of abstraction here.  Does
anyone know if there is an API call or something which will eliminate tables
from the list of choices?  Any way we can hide the tables from view like
Microsoft does with their System Objects?  Any help would be greatly
appreciated!

Thanks!

John A. Olson
[e-mail]
Computing Devices International
Bloomington, MN
=========================================================================
Date:         Tue, 19 Oct 1993 16:10:51 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Re: How can I hide tables?

% I'm trying to do something a little unusual here.  I have some tables
% (attached) in my db and some queries defined.  What I would like to do is
% hide the attached tables in such a way as to eliminate them from the list
% when the user makes a query.  In other words, as we all know, when defining
% a query, we are given a list of Tables/Queries to choose from as our
% sources.  What I want to do is have this list limited to only a list of
% queries to choose from.  I don't want the users to even see the table names
% listed as options.  I'm trying to create a layer of abstraction here.  Does
% anyone know if there is an API call or something which will eliminate tables
% from the list of choices?  Any way we can hide the tables from view like
% Microsoft does with their System Objects?  Any help would be greatly
% appreciated!


Since you are allowing the user to create queries, is it safe to assume you are
 allowing
them to use the full version of Access 1.x and not the ADK? (just curious)

If you had your own query wizard (ala Jennings in the Developer's Guide) this
 would be
easily taken care of because you could build a table of tables and determine
 which
the user should be permitted to see (but the down side is you'd have another
 table to
maintain).

I was trying to see if there was a way to add abstraction by following the
 current
paradigm of putting data tables in one database and attached tables + code in a
 second
database, but I don't think you'll buy anything there.

As far as API calls go, Access really doesn't have an API library, but rather
 makes use
of other existing API libraries which don't know about Access.

I wonder if this hiding will be possible in future releases? :)
=========================================================================
Date:         Wed, 20 Oct 1993 07:24:29 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Michael Gordon <[e-mail]>
Subject:      Re: ACCESS-L Digest - 17 Oct 1993 to 19 Oct 1993

>Subject: Re: Excel, Word upgrades?
>
>I read about both products in the latest copy of Windows magazine.  Also
>herd it should be towards December for a release date.  Cost of upgrading
>each will retail $129.00

The $129 is for a "competitive" upgrade; for previous users, the upgrade will
retain @ $99.

Michael D. Gordon
CIS: 71053,471
Internet: [e-mail]
Date sent:  20-OCT-1993 07:24:26
=========================================================================
Date:         Wed, 20 Oct 1993 07:55:09 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Thornton Prime <"Thorton_~Prime_at_lmu-acad1"@LMUMAIL.LMU.EDU>
Subject:      Changing the User without Leaving the Engine

     I am currently writing an application for Access that
     requires use by different users at the same station.  My
     problem is that I cannot change the User() without closing
     the database, exiting Access and then restarting Access.

     Does anyone know of a way to change the User without exiting
     the database, or at least without having to restart the
     Access Database engine?

     Thanks in advance,

     Thornton Prime
=========================================================================
Date:         Wed, 20 Oct 1993 13:31:18 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Scott Dahne <[e-mail]>
Subject:      Re: Excel, Word upgrades?

     I just got back from the product intro in Baltimore.  Excel 5.0, Word
     6.0, and Project 4.0.  They look great.  Many new features.  We'll all
     now go from using 20% of the feature set to about 10% of the set.
     Microsoft put out guides to the new features in Excel and Word which
     you can probably get from your local corporate representative.



______________________________ Reply Separator _________________________________
Subject: Excel, Word upgrades?
Author:  Microsoft Access Database Discussion List
<[e-mail]> at INTERNET
Date:    10/19/93 12:03 PM


Has anyone heard anything about the upgrades to MS-EXCEL, MS-Word for
Windows? Does anyone know where I can obtain press releases from
Microsoft?  I have heard it rumored that they'll be announced today, but
I've not heard anything more.

This may be a little "off the subject" of Access-L. But I hope someone out
there would know.
=========================================================================
Date:         Wed, 20 Oct 1993 10:59:00 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Kapczynski, Mark" <[e-mail]>
Subject:      security

I'm developing several databases on a Novell LAN.  Each user has their own
windows setup which includes the system.mda file.  If I'm developing a
database with the access security tools how can I allow the users to share
the system.mda file without forcing everyone on the LAN to have to use the
security login?  Also, what is to stop a user from deleting or copying the
system.mda file if it is on a shared directory?   One more question, has
anyone heard of the file SECWIZ.ZIP available on compuserv?  I don't have
compuserv and was wondering how I could FTP to it somewhere?  Thanks in
advance...


Mark Kapczynski
Programmer/Analyst
UCLA-NPI
310-206-7126
[e-mail]
=========================================================================
Date:         Wed, 20 Oct 1993 15:10:00 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Jones, Ryan" <[e-mail]>
Subject:      Better Report Wizard??? Other Wizards?? 3rd Party??

Hi!

I;m looking for some better Wizards then what comes with Access...For
instance a Report wizard that will format for a certain size
sheet...Portrait/Landscape and so on..
Does anyone know of any shareware or third-party wizards???

Thanks!

[e-mail]
=========================================================================
Date:         Thu, 21 Oct 1993 11:34:34 +0930
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         A J Howard <[e-mail]>
Subject:      sub ACCESS-L

Thanks
--
--------------------------------------------------------------------------------
Anthony Howard
CS-Club Member
[e-mail]
--------------------------------------------------------------------------------
=========================================================================
Date:         Thu, 21 Oct 1993 10:08:27 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Better Report Wizard??? Other Wizards?? 3rd Party??

% I;m looking for some better Wizards then what comes with Access...For
% instance a Report wizard that will format for a certain size
% sheet...Portrait/Landscape and so on..
% Does anyone know of any shareware or third-party wizards???

I'm not sure "better" is an appropriate word -- some of the wizards I've seen
 have been very, very simple
and perform very specific tasks (bottom line:  just because something doesn't do
 exactly what one wants,
it's not automatically "bad").

There are a large number of 3rd party vendors.  Also, you could write your own
 wizard -- it's not that
difficult!
=========================================================================
Date:         Thu, 21 Oct 1993 15:11:00 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Ellington, Robert W (Bob)" <[e-mail]>
Subject:      Determine Current Record Number?

Seeing as how MS Access itself has the ability to show what record number
you are on, how can I write a function that will tell me what record I am on
in a dynaset?  I got a copy of counter.mdb but the method they use is too
slow.  (Go to first record in the dynaset and do a movenext until the key is
the same as the one on screen) Surely there is a function call that can give
me this info quickly.


Any help in this area would be appreciated.
Bob Ellington
[e-mail]
=========================================================================
Date:         Thu, 21 Oct 1993 17:02:21 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Determine Current Record Number?

% Seeing as how MS Access itself has the ability to show what record number
% you are on, how can I write a function that will tell me what record I am on
% in a dynaset?  I got a copy of counter.mdb but the method they use is too
% slow.  (Go to first record in the dynaset and do a movenext until the key is
% the same as the one on screen) Surely there is a function call that can give
% me this info quickly.

Nope. And my name isn't Shirley.  (sorry, couldn't resist)

You've hit upon one of the small, but irritating oversights on the
part of the design people.  All the way back in the 1.0 Beta, this
was cited and the reply was "it's not needed" and the purists loudly
cried "it defies the true spirit of a relational database" (particularly
since the order of data is so fluid in queries and whatnot.

The real conflict is why does Access (itself) provide information which is
inaccessible to the developer and/or user?


---------------------------------------------------------------------
phil paxton
development editor
sams/prentice hall computer publishing  <=== "GO SAMS" via Compuserve
paramount publishing
indianapolis, indiana
=========================================================================
Date:         Thu, 21 Oct 1993 15:57:02 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Mark T Wignall <[e-mail]>
Subject:      Access Serial Communication

Hello Any/All!

I am in DESPERATE in my attempts at tring to find a good way to allow
MS Access to communicate through the Rs-232 ports (ala COMx) and am not
having any luck finding it in the documentation.

Question:
   Is there some nice and easy way to do this, or will I have to revert
to using WinAPI calls to accomplish this?

   I'm not trying to do anything fancy, just send some strings, and input
some strings.  I tried the Open statement using the "COMx: 4800,N,8,1" as
the file name, but no luck, bad file name.

Any/All help would be appreciated, and if I could get a response back REAL
soon, then I'd be even MORE appreciative.  I'm basically stuck and can't
continue until this issue is resolved.

Thanks again!

Mark Wignall
[e-mail]
=========================================================================
Date:         Fri, 22 Oct 1993 10:13:56 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Con Zymaris <[e-mail]>
Organization: CSIRO, Div. Building Constr. and Eng'ing, Melb., Australia
Subject:      Re: Access Serial Communication
In-Reply-To:  <[e-mail]>; from "Mark T
              Wignall" at Oct 21, 93 3:57 pm

According to Mark T Wignall:
>
> Hello Any/All!
>
> I am in DESPERATE in my attempts at tring to find a good way to allow
> MS Access to communicate through the Rs-232 ports (ala COMx) and am not
> having any luck finding it in the documentation.
>
> Question:
>    Is there some nice and easy way to do this, or will I have to revert
> to using WinAPI calls to accomplish this?
>
>    I'm not trying to do anything fancy, just send some strings, and input
> some strings.  I tried the Open statement using the "COMx: 4800,N,8,1" as
> the file name, but no luck, bad file name.
>
> Any/All help would be appreciated, and if I could get a response back REAL
> soon, then I'd be even MORE appreciative.  I'm basically stuck and can't
> continue until this issue is resolved.
>
> Thanks again!
>
> Mark Wignall
> [e-mail]
>
Mark,
try to chase up any language independent Comms toolkits, implemented as DLL's.
Places to try are Greenleaf, Crescent software, and anyone else in the arena
who's adds appear in BasicPro, DDJ, CUJ etc etc.

--

| Con Zymaris                   Phone [phone]    |
| Cybersource Pty. Ltd.         FAX  [phone]     | Click Here...
| Software Services             1275a Malvern Rd.       |
| [e-mail]        Malvern 3144, Australia |
=========================================================================
Date:         Fri, 22 Oct 1993 11:43:16 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Craig Bourner <[e-mail]>
Subject:      Re: Access Serial Communication

> Hello Any/All!
>
> I am in DESPERATE in my attempts at tring to find a good way to allow
> MS Access to communicate through the Rs-232 ports (ala COMx) and am not
> having any luck finding it in the documentation.
>
> Question:
>    Is there some nice and easy way to do this, or will I have to revert
> to using WinAPI calls to accomplish this?
>
>    I'm not trying to do anything fancy, just send some strings, and input
> some strings.  I tried the Open statement using the "COMx: 4800,N,8,1" as
> the file name, but no luck, bad file name.
>
> Any/All help would be appreciated, and if I could get a response back REAL
> soon, then I'd be even MORE appreciative.  I'm basically stuck and can't
> continue until this issue is resolved.
>
> Thanks again!
>
> Mark Wignall
> [e-mail]

This solution is a bit messy, but you could try writing a generic routine
in VB 3.0 Pro using the serial communications custom control, and then sending
data to it from MS-ACCESS using DDE.  This is better than using API calls,
but not by very much.

--
Craig Bourner                                      AARNET: [e-mail]
Computer Power Software Pty. Ltd. (ACN 005692482)  Voice: [phone]
Division of the Computer Power Group
Melbourne, Australia
=========================================================================
Date:         Fri, 22 Oct 1993 12:03:21 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Craig Bourner <[e-mail]>
Subject:      Re: Determine Current Record NUmber?

> % Seeing as how MS Access itself has the ability to show what record number
> % you are on, how can I write a function that will tell me what record I am on
> % in a dynaset?  I got a copy of counter.mdb but the method they use is too
> % slow.  (Go to first record in the dynaset and do a movenext until the key is
> % the same as the one on screen) Surely there is a function call that can give
> % me this info quickly.
>
> Nope. And my name isn't Shirley.  (sorry, couldn't resist)
>
> You've hit upon one of the small, but irritating oversights on the
> part of the design people.  All the way back in the 1.0 Beta, this
> was cited and the reply was "it's not needed" and the purists loudly
> cried "it defies the true spirit of a relational database" (particularly
> since the order of data is so fluid in queries and whatnot.
>
> The real conflict is why does Access (itself) provide information which is
> inaccessible to the developer and/or user?

One method that might be faster that the counter.mdb you describe would be to
create the dynaset, the perform a one-off update using the index along which
it will be accessed in your example, and update each record with a series
number.  This is not nice because you will have to carry an extra field in
your database, and if the dynaset is very large this will be a problem.  This
solution also assumes that you are creating the dynaset from code, rather
than using a table or query on a form.

--
Craig Bourner                                      AARNET: [e-mail]
Computer Power Software Pty. Ltd. (ACN 005692482)  Voice: [phone]
Division of the Computer Power Group
Melbourne, Australia

--
Craig Bourner                                      AARNET: [e-mail]
Computer Power Software Pty. Ltd. (ACN 005692482)  Voice: [phone]
Division of the Computer Power Group
Melbourne, Australia
=========================================================================
Date:         Fri, 22 Oct 1993 11:01:15 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Sheryl Smoot <[e-mail]>
Subject:      What is the .LDB used for?

     (Forgive me if this question has been asked before)
     What is the .LDB file that Access creates used for?

     TIA!

     Sherry
     *******************************
     [e-mail]
     American Management Systems, Arlington, VA
=========================================================================
Date:         Fri, 22 Oct 1993 10:25:00 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Ellington, Robert W (Bob)" <[e-mail]>
Subject:      Re: Determine Current Record NUmber?

>------------------------------
>
>Date:    Fri, 22 Oct 1993 12:03:21 EST
>From:    Craig Bourner <[e-mail]>
>Subject: Re: Determine Current Record NUmber?
>
>> % Seeing as how MS Access itself has the ability to show what record
number
>> % you are on, how can I write a function that will tell me what record I
am
>on
>> % in a dynaset?  I got a copy of counter.mdb but the method they use is
too
>> % slow.  (Go to first record in the dynaset and do a movenext until the
key
>is
>> % the same as the one on screen) Surely there is a function call that can
>give
>> % me this info quickly.
>>
>> Nope. And my name isn't Shirley.  (sorry, couldn't resist)
>>
>> You've hit upon one of the small, but irritating oversights on the
>> part of the design people.  All the way back in the 1.0 Beta, this
>> was cited and the reply was "it's not needed" and the purists loudly
>> cried "it defies the true spirit of a relational database" (particularly
>> since the order of data is so fluid in queries and whatnot.
>>
>> The real conflict is why does Access (itself) provide information which
is
>> inaccessible to the developer and/or user?
>
>One method that might be faster that the counter.mdb you describe would be
to
>create the dynaset, the perform a one-off update using the index along
which
>it will be accessed in your example, and update each record with a series
>number.  This is not nice because you will have to carry an extra field in
>your database, and if the dynaset is very large this will be a problem.
 This
>solution also assumes that you are creating the dynaset from code, rather
>than using a table or query on a form.
>
>--
>Craig Bourner                                      AARNET:
>[e-mail]
>Computer Power Software Pty. Ltd. (ACN 005692482)  Voice: [phone]
>Division of the Computer Power Group
>Melbourne, Australia
>

Unfortunately I am getting this dynaset via the form.  Also I am using ODBC
to hit
Informix tables, which contain > 40,000 records, and am also wanting a
faster method
of determining the total count of records.  Do any of you know if the new
version
coming out soon will have better "access" to this information?  I may just
have to
wait.

Thanks for the responses
Bob Ellington
[e-mail]
=========================================================================
Date:         Fri, 22 Oct 1993 09:57:57 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Mark=[e-mail]
Subject:      Access .LDB files

Sheryl Smoot <[e-mail]> Wrote:
|
|
|      (Forgive me if this question has been asked before)
|      What is the .LDB file that Access creates used for?
|
|      TIA!
|
|      Sherry
|      *******************************
|      [e-mail]
|      American Management Systems, Arlington, VA

They are the Locking Data Base files that Access generates to keep track
of records that are locked so in a multi-user environment, simultaneous
users can't modify the same record.

These files can be deleted before starting Access if you want, because
Access will just recreate them if it needs to.

Mark Wignall
Tektronix - GPID Print Head Mfg.
=========================================================================
Date:         Fri, 22 Oct 1993 15:42:09 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Tkachuck <[e-mail]>
Subject:      Extra Page
In-Reply-To:  <[e-mail]>

Am a new user of Access and have run into a little problem.  I created a
multiple column table with Wizzard.  It ran over to two pages, which if
held side by side would have all the columns represented.  I eliminated a
couple columns and got them all on one page.  Adjusted the header so it
was all on one page.  But when I print out the report I get the first
page with the proper columns and then a blank page.  The third page has a
continuation of the report, and the forth page is blank and so on.  Would
like to save a tree and have only the pages with the columns printed.

Thanks.

Richard Tkachuck               AskERIC Coordinator
AskERIC:  ERIC Clearinghouse,  030 Huntington Hall
Syracuse University, Syracuse, NY 13210
Phone:  [phone]           FAX [phone]
email:  [e-mail]
=========================================================================
Date:         Fri, 22 Oct 1993 15:45:21 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: Extra Page
In-Reply-To:  Richard Tkachuck <[e-mail]> "Extra Page" (Oct 22,
              3:42pm)

Richard,

After you deleted the extra columns and re-sized the header on your report, it
sounds like you forgot to re-size the page boundary on the right size. Or, in
other words, you moved everything over but the "white area". If, for instance,
you margins are 1" on both sides, the right side of the white area should line
up under 6.5".

This is my best guess. If this is not your problem, then I'm stumped.

Tony Hamilton
Intel Corporation
[e-mail]
=========================================================================
Date:         Sat, 23 Oct 1993 06:06:32 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Stephen Hueners <[e-mail]>
Subject:      Re: Extra Page

There has to be some element like a ruling line at the very top or very
bottom of one or more sections of the report. Use Tab key to cycle through
all objects.

Frustrating, is'nt it?

--steve...
=========================================================================
Date:         Sat, 23 Oct 1993 22:23:39 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Craig Bourner <[e-mail]>
Subject:      Re: Determine Current Record Number

Robert Wellington writes:

> Unfortunately I am getting this dynaset via the form.  Also I am using ODBC
> to hit
> Informix tables, which contain > 40,000 records, and am also wanting a
> faster method
> of determining the total count of records.  Do any of you know if the new
> version
> coming out soon will have better "access" to this information?  I may just
> have to
> wait.

No idea about the next version (can anyone else help ?).  I have had a bit
of a think about this one, and I have another suggestion.  Try using the
"OnCurrent" property to call an Access Basic function which maintains a
position counter.  You can increment the counter if the value of the index
along which you are moving is greater than the previous (saved) value.  You
can decrement it is it is less.  At the end of this function, you can
ecord the current index value for comparison the next time the record
changes.

This might be useless if the dynaset is to have records inserted - access
doesn't re-order them until the dynaset is closed (I think - it's been a while)

To count the number of records, you could:

1.  Trap every insert and delete and maintain a counter in another table.  The
    change impact here might be a bit too big, though.

2.  Try using DCount() - this is probably the fastest method provided by Access.

If none of this is useful, someone else can try !

--
Craig Bourner                                     AARNET: [e-mail]
=========================================================================
Date:         Sun, 24 Oct 1993 12:54:36 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      more on extra pages

I had a similar problem with an extra page on printing some reports. I had
some continuous reports that I needed to divide up with page breaks.

Therein was my problem: the page break had to be EXACTLY right...otherwise
I got an extra page. I'm still not certain what needed to be done...but
futzing around with the page break cleared up my problem.

And, yes, it IS frustrating.

Harry Yeatts (HYEATTS)                INTERNET: VTVM1.CC.VT.EDU
Virginia Tech                         BITNET: VTVM1
Blacksburg, Virginia                  PHONE: [phone]
=========================================================================
Date:         Sun, 24 Oct 1993 10:33:18 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Ron Apland <[e-mail]>
Subject:      Re: more on extra pages

>I had a similar problem with an extra page on printing some reports. I had
>some continuous reports that I needed to divide up with page breaks.
>
>Therein was my problem: the page break had to be EXACTLY right...otherwise
>I got an extra page. I'm still not certain what needed to be done...but
>futzing around with the page break cleared up my problem.
>
>And, yes, it IS frustrating.

Sorry if this has already been covered. I just ran into the same thing and
found that it was the width of the page.  Very simple.  It was printing all
the data I had asked but since I didn't pay attention to the page width it
thought I wanted more in the blank area on the right outside the width of
my page - so it put it on another page - which of course was blank!  To
fix it, if you are using an 8.5" page with .5" margins, make sure the page
does not go over 7.5" by grabbing the right page margin and dragging it to
the proper width.

Ron
=========================================================================
Date:         Sun, 24 Oct 1993 13:22:24 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Linda D. Cornell" <[e-mail]>
Subject:      Need Help with Condition Expression

Hi there,

We want to pass a value that we have grabbed from a form and use it in a
between Condition Expression.  The problem is that the expression doesn't
seem to like us using variables - it wants us to hard code our dates.

What we want is something like:

=IIf([Rept_Date] Between [Month_Start] And [Month_End],expression1,expression2)

Where we don't have to explicity specify #08/01/93# as Month_Start and
#08/31/93# as month end - we want to pull the fields out of a "System Table".

Fun and games with syntax!  Thanks in advance for any pointers!

Linda Cornell
[e-mail]
University of Washington
Office of Research
=========================================================================
Date:         Sun, 24 Oct 1993 14:39:10 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Need Help with Condition Expression
In-Reply-To:  <[e-mail]> from "Linda D. Cornell" at Oct
              24, 93 01:22:24 pm

Linda,

Build your query with the conditionals in the query builder.  Make sure
it runs.  Go into View, SQL.  Highlight the text, and use Ctrl-C to copy
it into the clipboard.  You now need to create a module, and paste the
SQL into the module.  Assign the SQL to a text string. Paste your
control values into the text string.  Build your dynaset from the text
string.  IE:

I am skipping all of the declarations

Set D=CurrentDB()
Set F=Forms!myform
VariableToPaste = F![MyVariable]

strSQL = "Select DISTINCTROW Stuff, MoreStuff from MyTable where "
strSQL = strSQL & "MoreStuff = #" & VariableToPaste & " Blah Blah Blah"

set MyDynaset = D.CreateDynaset(strSQL)

This is a short and ugly demonstration of what you need to do.
Basicaly, you paste the _value_ of the form variable into your query.

Hope this helps.

John
=========================================================================
Date:         Mon, 25 Oct 1993 12:02:02 GMT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Richard Saunders,
              Computer Centre" <[e-mail]>
Organization: University Of East London
Subject:      Dynamic allocation of record source property

I have about 60 tables of name and address labels. Their structures
are identical, but I don't want to merge them into a single table. Is
there any way to use a single form and a single report and
assign a table name to their record source property each time I
want to print labels for that particular table?

Alternatively, what other approaches could I use? I thought of
copying or renaming the table to a specific name each time, then
changing its name back afterwards, but I am not sure if it's
feasible. I would be grateful for any suggestions. Thanks.
=========================================================================
Date:         Mon, 25 Oct 1993 08:25:12 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Organization: University of Texas Health Science Center at San Antonio
Subject:      Re: Command confirmation request (2095C2)

I have been having problems getting my confirmation code
to pass.  I have tried about 5 times to subscribe and
reply with the OK command.  All I get back is that my
code is incorrect or it has been too long.
Can somebody help me please...
                Kevin Muenzler
                        [e-mail]
=========================================================================
Date:         Mon, 25 Oct 1993 09:39:38 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Warning -- RSCS tag indicates an origin of HENSLEY@HUSC3
From:         KENTON HENSLEY 617-496-2131 <[e-mail]>
Subject:      Fill function for Combo Box

Has anyone created a fill function for a combo box that returns a dynaset
variable?  I want to create a dynaset where the records are limited by the
value in another control on the form.  The function will be called from
the On Enter property of the combo box.

Before I tackled this baby I thought I'd get comments from the experienced,
if any, in this area.

Kenton Henlsey
[e-mail]
=========================================================================
Date:         Mon, 25 Oct 1993 07:15:22 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Bill Stewart <[e-mail]>

confirm access-l
=========================================================================
Date:         Mon, 25 Oct 1993 09:42:10 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         QLM_OOPS ext 2104 Anyone for some drywall mudding?
              <[e-mail]>
Subject:      Zip code database table?

I remember seeing in a pas post to this list a reference to a pre-made
table that contained the zip codes with proper city/state fill-ins.  I have
deleted such posts and was wondering if someone would be kind enough to
please post the information again as to where I might obtain this file.
Either a private message to [e-mail] or a post to this list
would be just fine.  Thank you very much in advance!!

sean
=========================================================================
Date:         Tue, 26 Oct 1993 00:42:57 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Craig Bourner <[e-mail]>
Subject:      Dynamic allocation of record source property (fwd)

>
> I have about 60 tables of name and address labels. Their structures
> are identical, but I don't want to merge them into a single table. Is
> there any way to use a single form and a single report and
> assign a table name to their record source property each time I
> want to print labels for that particular table?

It depends on how you access and manipulate the data.  If I saw a database
like this, I would re-organize it into about 60 categories (I assume you
don't wish to merge them because they are logically grouped at the moment)
to facilitate convenient access.  Introducing an additional field (which may
also be required to be part of an index) would be required if you took
this approach.

> Alternatively, what other approaches could I use? I thought of
> copying or renaming the table to a specific name each time, then
> changing its name back afterwards, but I am not sure if it's
> feasible. I would be grateful for any suggestions. Thanks.

You could access a selected table from reasonably re-usable code if you
first created a dynaset, using the appropriate table name in the SQL
statement.  Using this data from a form or a report could be a real problem
though.

--
Craig Bourner                                     AARNET: [e-mail]
=========================================================================
Date:         Tue, 26 Oct 1993 00:45:08 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Craig Bourner <[e-mail]>
Subject:      Re: Command confirmation request (2095C2) (fwd)

>
> I have been having problems getting my confirmation code
> to pass.  I have tried about 5 times to subscribe and
> reply with the OK command.  All I get back is that my
> code is incorrect or it has been too long.
> Can somebody help me please...

I can't help, because the same thing happens to me.  I got told that I am no
longer subscribed, so I sent off a SUB ACCESS-L and then got told that I was
already subscribed !  I have not stopped receiving mail, so I will be
ignoring this problem.

--
Craig Bourner                                     AARNET: [e-mail]
=========================================================================
Date:         Mon, 25 Oct 1993 10:30:56 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Dynamic allocation of record source property

% From: "Richard Saunders,              Computer Centre",
% INTERNET:[e-mail]
% I have about 60 tables of name and address labels. Their structures
% are identical, but I don't want to merge them into a single table. Is
% there any way to use a single form and a single report and
% assign a table name to their record source property each time I
% want to print labels for that particular table?

Not yet. (the operative word, I believe is "yet") :)
=========================================================================
Date:         Mon, 25 Oct 1993 10:35:25 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Re: Command confirmation request (2095C2)

% From: INTERNET:[e-mail],
% INTERNET:[e-mail]
% From: [e-mail]

% I have been having problems getting my confirmation code
% to pass.  I have tried about 5 times to subscribe and
% reply with the OK command.  All I get back is that my
% code is incorrect or it has been too long.
% Can somebody help me please...
%                 Kevin Muenzler
%                         [e-mail]

I can't but did want to point out it looks as though you have
a rather convoluted route for your subscription.  With a
full Internet domain name, one would think it'd be
subscribed to indycms.iupui.edu...(not routed)

I'd look at the REV list myself, but I have a couple of books
due to go 100% into Production this week (including Roger
Jennings' latest....every bit as good as the Access Dev Gde!)

---------------------------------------------------------------------
phil paxton
development editor
sams/prentice hall computer publishing  <=== "GO SAMS" via Compuserve
paramount publishing
indianapolis, indiana
=========================================================================
Date:         Mon, 25 Oct 1993 10:24:32 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      ACCESS-L FAQ--Quarterly Posting

ACCESS-L FAQ (Frequently-Asked Questions)
For ACCESS-L@INDYCMS, Microsoft Access Database Discussion List
Version 1.1, 10/25/93
============================================================
This FAQ will be posted to the list at large on a quarterly basis.
It can be retrieved at any time from LISTSERV@INDYCMS with the command
GET ACCESS-L FAQ.
============================================================

Q. What is ACCESS-L?

A. ACCESS-L@INDYCMS is a BITNET distribution list running under LISTSERV
1.7f at INDYCMS, the VM computer at Indiana University Purdue University
Indianapolis.  ACCESS-L is provided for the discussion of Microsoft
Access, a relational database product for Microsoft Windows 3.x.

   DISCLAIMER:  Indiana University is <not responsible> for either the
content or the management of the list.  The list administrator's
responsibilities are limited to keeping the list focused and tending to
various administrative duties related to the list.  Those who post to
ACCESS-L are solely responsible for the content of their posts.  Any and
all software, either posted across ACCESS-L or residing in the list
archives is downloaded and used at the downloader's own risk.

   Note that there are THREE ACCESS-L lists on BITNET.  One is ACCESS-
L@INDYCMS, this list; one is ACCESS-L@BRUFPB, a Brazilian Microsoft
Access list (one assumes without supporting data that it is in
Portugese); and the last is ACCESS-L@UNBVM1, which has nothing to do
with Microsoft Access at all.


============================================================
Q. Does Microsoft Corporation sponsor ACCESS-L?

A. No.  The list is not sponsored in any way by Microsoft, although
Microsoft employees and particularly Access design staff are welcome and
encouraged to subscribe.

============================================================
Q. What is the format for sending commands to LISTSERV?

A. First of all, be sure you send them to LISTSERV and not to the list.
Second, there are two ways to send the commands:  Interactively and via
Mail.

   Interactive commands differ between systems (and are not available on
all systems anyway--e.g., AOL and CompuServe).  They would be of the
general format:

    (For VM/CMS:)  TELL LISTSERV AT INDYCMS <command>

    (For VAX/VMS:) SEND LISTSERV@INDYCMS <command>

    For other systems, see your consultants.  For specifics on LISTSERV
commands, send the command GET LISTSERV REFCARD to LISTSERV@INDYCMS.

   Mail commands can be more efficient if the network is experiencing
its usual glitches--at least the command will eventually be processed by
LISTSERV.  To send commands by mail, simply address a message to
LISTSERV@INDYCMS (or [e-mail]) with a blank subject
line and the command you want to send as the body of the message.  You
can send up to five commands at a time in this way, but be forewarned--
if one of the commands triggers an error, all subsequent commands in the
message will be flushed without being processed.  (LISTSERV will count
your signature line (if any) as an error but this should not cause a
problem since it comes last.)

============================================================
Q. How do I subscribe to or unsubscribe from ACCESS-L?

A. To subscribe to ACCESS-L, send the command

   SUB ACCESS-L <Your_Name>

   to [e-mail].

   To unsubscribe from ACCESS-L, send the command

   UNSUB ACCESS-L

   to [e-mail].

============================================================
Q. What if I try to unsubscribe (or am asked to confirm my subscription
after 6 months) and am told I do not appear in the list?

A. You are either a) subscribed via a redistribution list (such as MS-
ACCESS) or b) your Internet address has changed slightly and LISTSERV
does not recognize your ID.  You can get a copy of the subscriber list
by sending the command REV ACCESS-L to LISTSERV@INDYCMS.

   Also note that if you used SEND or TELL to interactively subscribe
and subsequently send mail to [e-mail] to set
commands, the listserver may not recognize you because you are
subscribed under a BITNET address and are sending commands from an
Intern:JbyVoM8>.  One possible solution to this problem would be to
mail your commands to LISTSERV@INDYCMS rather than to the Internet
address.

   If you can't figure the problem out, do <NOT> post a message to the
list at large to unsubscribe you or to confirm you.  Send all such mail
directly to the list administrator.  See below.

============================================================
Q. Somehow I got my hands on this FAQ but I can't seem to get a reaction
from the listserver when I try to subscribe.  Why is that?

A. ACCESS-L is set up to confirm a mailing path back to all new
subscribers.  This is done by sending a message back to the address on
the subscription request which has a unique confirmation code.  The
subscriber is asked to send that confirmation code back to LISTSERV.
   Because some Internet gateways aren't always two-way, your
confirmation message probably did not get back to you, meaning that
LISTSERV could not send you mail even if the list administrator added
you manually.  This is a network problem and isn't currently solvable
unless you can provide a substitute (i.e., BITNET) address.  You might
try subscribing from another account or subscribing to a redistribution
list.

============================================================
Q.  I sent back my confirmation code for subscription but I keep getting
error messages from the listserver that say my confirmation code doesn't
apply to any existing job.  Why is that?

A.  LISTSERV expects the confirmation codes to be sent in a specific way
because some mail gateways add lines to the header of the message that
LISTSERV doesn't understand.  The subscription sequence should be as
follows:

1.  SEND Subscription request
2.  REPLY to the confirmation request ('ok')
3.  SEND the confirmation code (if necessary) ('ok 23CBD8', for
instance)
4.  Send mail to the LIST ADMINISTRATOR, not to the list, if your
subscription request fails after step 3.  (See below)
============================================================
Q. Who is the list administrator and how do I contact him?

A. The list administrator is Nathan Brindle, NBRINDLE@INDYCMS.  His
Internet address is [e-mail].

============================================================
Q. How do I get a copy of old postings (list archives)?

A. Send the command GET ACCESS-L LOGYYMM to LISTSERV@INDYCMS, where YYMM
is the year and month of the archive you want (i.e., LOG9302 is for
February 1993).

============================================================
Q. How do I get an index of list archives and other files
   related to the list?

A. Send the command IND ACCESS-L to LISTSERV@INDYCMS.

============================================================
Q. If I want to FTP files associated with ACCESS-L rather than request
them through the listserver, how do I do that?

A. At the moment, the list administrator is "mirroring" all files from
the list archives (except for the message logs themselves) to
FTP.CICA.INDIANA.EDU.  This may change, but for the moment it's all we
can do.  Newer files are located in the pub/pc/win3/uploads directory
there; older ones will be relocated at some point by CICA into
pub/pc/win3/access.  Naturally you should feel free to use CICA's mirror
sites as well.

============================================================
Q. I have a GREAT .MDB to share with everyone on the list.  If I
uuencode it, should I send it to the list?

A. Those conversant with netiquette would probably reply in the
negative.  Even the smallest .MDB is going to be larger than most people
want to find in their mailbox, particularly since the file is going to
be somewhat larger than it would be in binary format anyway.  Also
remember that some people are paying for their messages and may not be
particularly appreciative of receiving a long file they didn't ask for;
and not everyone has UUdecoding software, either.

   If you wish to share a file with the rest of the list, you are
encouraged to upload it to CICA or to send it to the list administrator
in private mail with a request that he include it in the list archives.
(Such requests should include an abstract of what the file does and/or
what it includes.)

   Also, because the list is "digestified" and digests typically
truncate at 1000 or 1500 lines, you may crowd some posts out with a long
UUencoded message.  There have also been reports from people on America
Online that long posts from the Internet are usually cut short on their
service.

============================================================
Q. I've found a review or article in a computer magazine that relates to
a discussion taking place.  May I post the review or article to the
list?

A. If you can summarize the review or article in your own words, feel
free to do so.  Otherwise, please refrain from posting copyrighted
materials to the list.  (You can always cite the article in question so
others can look it up.)

*END OF FILE*

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Mon, 25 Oct 1993 10:27:11 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      ACCESS-L FAQ--Quarterly Posting

ACCESS-L FAQ (Frequently-Asked Questions)
For ACCESS-L@INDYCMS, Microsoft Access Database Discussion List
Version 1.1, 10/25/93
============================================================
This FAQ will be posted to the list at large on a quarterly basis.
It can be retrieved at any time from LISTSERV@INDYCMS with the command
GET ACCESS-L FAQ.
============================================================

Q. What is ACCESS-L?

A. ACCESS-L@INDYCMS is a BITNET distribution list running under LISTSERV
1.7f at INDYCMS, the VM computer at Indiana University Purdue University
Indianapolis.  ACCESS-L is provided for the discussion of Microsoft
Access, a relational database product for Microsoft Windows 3.x.

   DISCLAIMER:  Indiana University is <not responsible> for either the
content or the management of the list.  The list administrator's
responsibilities are limited to keeping the list focused and tending to
various administrative duties related to the list.  Those who post to
ACCESS-L are solely responsible for the content of their posts.  Any and
all software, either posted across ACCESS-L or residing in the list
archives is downloaded and used at the downloader's own risk.

   Note that there are THREE ACCESS-L lists on BITNET.  One is ACCESS-
L@INDYCMS, this list; one is ACCESS-L@BRUFPB, a Brazilian Microsoft
Access list (one assumes without supporting data that it is in
Portugese); and the last is ACCESS-L@UNBVM1, which has nothing to do
with Microsoft Access at all.


============================================================
Q. Does Microsoft Corporation sponsor ACCESS-L?

A. No.  The list is not sponsored in any way by Microsoft, although
Microsoft employees and particularly Access design staff are welcome and
encouraged to subscribe.

============================================================
Q. What is the format for sending commands to LISTSERV?

A. First of all, be sure you send them to LISTSERV and not to the list.
Second, there are two ways to send the commands:  Interactively and via
Mail.

   Interactive commands differ between systems (and are not available on
all systems anyway--e.g., AOL and CompuServe).  They would be of the
general format:

    (For VM/CMS:)  TELL LISTSERV AT INDYCMS <command>

    (For VAX/VMS:) SEND LISTSERV@INDYCMS <command>

    For other systems, see your consultants.  For specifics on LISTSERV
commands, send the command GET LISTSERV REFCARD to LISTSERV@INDYCMS.

   Mail commands can be more efficient if the network is experiencing
its usual glitches--at least the command will eventually be processed by
LISTSERV.  To send commands by mail, simply address a message to
LISTSERV@INDYCMS (or [e-mail]) with a blank subject
line and the command you want to send as the body of the message.  You
can send up to five commands at a time in this way, but be forewarned--
if one of the commands triggers an error, all subsequent commands in the
message will be flushed without being processed.  (LISTSERV will count
your signature line (if any) as an error but this should not cause a
problem since it comes last.)

============================================================
Q. How do I subscribe to or unsubscribe from ACCESS-L?

A. To subscribe to ACCESS-L, send the command

   SUB ACCESS-L <Your_Name>

   to [e-mail].

   To unsubscribe from ACCESS-L, send the command

   UNSUB ACCESS-L

   to [e-mail].

============================================================
Q. What if I try to unsubscribe (or am asked to confirm my subscription
after 6 months) and am told I do not appear in the list?

A. You are either a) subscribed via a redistribution list (such as MS-
ACCESS) or b) your Internet address has changed slightly and LISTSERV
does not recognize your ID.  You can get a copy of the subscriber list
by sending the command REV ACCESS-L to LISTSERV@INDYCMS.

   Also note that if you used SEND or TELL to interactively subscribe
and subsequently send mail to [e-mail] to set
commands, the listserver may not recognize you because you are
subscribed under a BITNET address and are sending commands from an
Internet address.  One possible solution to this problem would be to
mail your commands to LISTSERV@INDYCMS rather than to the Internet
address.

   If you can't figure the problem out, do <NOT> post a message to the
list at large to unsubscribe you or to confirm you.  Send all such mail
directly to the list administrator.  See below.

============================================================
Q. Somehow I got my hands on this FAQ but I can't seem to get a reaction
from the listserver when I try to subscribe.  Why is that?

A. ACCESS-L is set up to confirm a mailing path back to all new
subscribers.  This is done by sending a message back to the address on
the subscription request which has a unique confirmation code.  The
subscriber is asked to send that confirmation code back to LISTSERV.
   Because some Internet gateways aren't always two-way, your
confirmation message probably did not get back to you, meaning that
LISTSERV could not send you mail even if the list administrator added
you manually.  This is a network problem and isn't currently solvable
unless you can provide a substitute (i.e., BITNET) address.  You might
try subscribing from another account or subscribing to a redistribution
list.

============================================================
Q.  I sent back my confirmation code for subscription but I keep getting
error messages from the listserver that say my confirmation code doesn't
apply to any existing job.  Why is that?

A.  LISTSERV expects the confirmation codes to be sent in a specific way
because some mail gateways add lines to the header of the message that
LISTSERV doesn't understand.  The subscription sequence should be as
follows:

1.  SEND Subscription request
2.  REPLY to the confirmation request ('ok')
3.  SEND the confirmation code (if necessary) ('ok 23CBD8', for
instance)
4.  Send mail to the LIST ADMINISTRATOR, not to the list, if your
subscription request fails after step 3.  (See below)
============================================================
Q. Who is the list administrator and how do I contact him?

A. The list administrator is Nathan Brindle, NBRINDLE@INDYCMS.  His
Internet address is [e-mail].

============================================================
Q. How do I get a copy of old postings (list archives)?

A. Send the command GET ACCESS-L LOGYYMM to LISTSERV@INDYCMS, where YYMM
is the year and month of the archive you want (i.e., LOG9302 is for
February 1993).

============================================================
Q. How do I get an index of list archives and other files
   related to the list?

A. Send the command IND ACCESS-L to LISTSERV@INDYCMS.

============================================================
Q. If I want to FTP files associated with ACCESS-L rather than request
them through the listserver, how do I do that?

A. At the moment, the list administrator is "mirroring" all files from
the list archives (except for the message logs themselves) to
FTP.CICA.INDIANA.EDU.  This may change, but for the moment it's all we
can do.  Newer files are located in the pub/pc/win3/uploads directory
there; older ones will be relocated at some point by CICA into
pub/pc/win3/access.  Naturally you should feel free to use CICA's mirror
sites as well.

============================================================
Q. I have a GREAT .MDB to share with everyone on the list.  If I
uuencode it, should I send it to the list?

A. Those conversant with netiquette would probably reply in the
negative.  Even the smallest .MDB is going to be larger than most people
want to find in their mailbox, particularly since the file is going to
be somewhat larger than it would be in binary format anyway.  Also
remember that some people are paying for their messages and may not be
particularly appreciative of receiving a long file they didn't ask for;
and not everyone has UUdecoding software, either.

   If you wish to share a file with the rest of the list, you are
encouraged to upload it to CICA or to send it to the list administrator
in private mail with a request that he include it in the list archives.
(Such requests should include an abstract of what the file does and/or
what it includes.)

   Also, because the list is "digestified" and digests typically
truncate at 1000 or 1500 lines, you may crowd some posts out with a long
UUencoded message.  There have also been reports from people on America
Online that long posts from the Internet are usually cut short on their
service.

============================================================
Q. I've found a review or article in a computer magazine that relates to
a discussion taking place.  May I post the review or article to the
list?

A. If you can summarize the review or article in your own words, feel
free to do so.  Otherwise, please refrain from posting copyrighted
materials to the list.  (You can always cite the article in question so
others can look it up.)

*END OF FILE*

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Mon, 25 Oct 1993 17:43:31 EST
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Pekka Koskinen <[e-mail]>
Subject:      Duplicate key -problem

Which one is a real dummy, Microsoft or me? Here's the problem:

    In my Windows (3.1) ControlPanel International -section settings
    I have the language defined as Finnish (because that's the language
    of the country...).

    Then I have an Access table with two fields:

               Field #1: 2-letter text (code)
               Field #2: Text (50 letters)

    In the field #1 I have codes (all unic values) like: SR, SU, SV, SW, etc

    Now I want to make it a primary key, but Access doesn't like the idea
    complaining about "duplicate keys" (and there are no duplicate keys!).
    Explanation: in Finnish alphabet sorting no difference is made
    between "v" and "w" (i.e. we sort: VAA, WAA, VBB, VHH etc (instead of
    VAA, VBB, VHH, WAA)).

    Question: Is there any other solution to make my field #1 a primary
    key except changing the language setting to "English"???

I hope that it's me, who turns out to be the real dummy (i.e. there's is a
solution), but based on my earlier experiments with those International
section settings I'm afraid it's Microsoft again... You be the judge!

G'day!
Pekka

*****************************************************************************
 Pekka Koskinen              :)
 CIMO, P.O. Box 343          :)         "Money can't buy happiness,
 00531 Helsinki, FINLAND     :)      so I guess I'll have to rent it."
 tel [phone]     :)
 fax [phone]     :)           ("Weird" Al Yankovic )
=========================================================================
Date:         Mon, 25 Oct 1993 09:48:58 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Re: Dynamic allocation of record source property
In-Reply-To:  <[e-mail]>; from "Richard Saunders,
              Computer Centre" at Oct 25, 93 12:02 pm

>
> I have about 60 tables of name and address labels. Their structures
> are identical, but I don't want to merge them into a single table. Is
> there any way to use a single form and a single report and
> assign a table name to their record source property each time I
> want to print labels for that particular table?
>
> Alternatively, what other approaches could I use? I thought of
> copying or renaming the table to a specific name each time, then
> changing its name back afterwards, but I am not sure if it's
> feasible. I would be grateful for any suggestions. Thanks.

Create a query.

Look at the SQL code.

Copy that to a function in a module.

sql = "Select from tablename ....."

change it to:

sql = "select from " & tablename_variable & " ..."

pass the tablename_variable to the function,
or, create a table of tablenames.....

use the function to run the query.

run the report aftert the query.
=========================================================================
Date:         Mon, 25 Oct 1993 12:24:50 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Jennings' Book

% What about Roger Jenning's latest? After the "Access Dev Gde", (one
% of the best Access books anywhere!), where can he go from there?

Oh, believe me, there's lots more where that came from!  If we
peaked already (tomorrow is one year for me), I'd leave!

Ahem:

"Database Developer's Guide with Visual Basic 3.0"  (0-672-30440-6)

It's for database programmers and developers who want to use VB3 to do
their thing thru the data manager / access engine.  Although there
are a lot of ties to the Access stuff in the manuscript, it's pretty
comprehensive and generic and extends into EIS (executive information
systems--much easier to implement in VB3 than Access), networks, etc.

Basically, if you think about the level & quality of Access 1.1
Developer's Guide (now on the bestseller list) and transfer it
to VB3 + database programming, you'll have a pretty good idea of
what's in it.

It's a killer book.  I'd tease you about what's next but it's
NDA right now...

---------------------------------------------------------------------
phil paxton
development editor
sams/prentice hall computer publishing  <=== "GO SAMS" via Compuserve
paramount publishing
indianapolis, indiana
=========================================================================
Date:         Mon, 25 Oct 1993 21:06:55 SAT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Sam Somuah <[e-mail]>
Organization: King Fahd University of Petroleum and Minerals, S.A.
Subject:      Appending Records

HELP!
I am new to Access and I have problems implementing some of the features
that I can accomplish easily in Clipper. This is the situation
I have an Access form that is based on a Table with fields such as

Field 1: aa
Field 2: bb
Field 3: cc

Once the form is completely filled Access appends the new record to the
fisrt table. I would however like to append the same record to a second
table. I tried an append query but it picks up all the records in the first
table where the value in field aa equals the value in field aa on the form
and appends it to the second table so that I end up with sometimes five new
records in the second table.
How do I get access to append only the new data entered on the form to the
second table


In Clipper the code will be like this
select A
append several fields to the first table
Select b
append the same fields to the second table

Any help from some expert will be great since I'm out of my wits.


Thanks.
Sam
<[e-mail])
=========================================================================
Date:         Tue, 26 Oct 1993 08:11:00 +1000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Kevin Anderson <[e-mail]>
Subject:      C Interface

Has anyone used or know of a C language interface to Access?

If no direct interface, can C call a VB subroutine that in
turn access the data.

I have a system in C, that I want to port to Access. The system
has a lot of complicated reports that I feel I probably may
not be able to duplicate in Access. I would therefore like to
keep the C reports and simply replace to existing IO calls with
calls to ACCESS directly (or thru VB)

?????

Any thoughts would be greatly appreciated..and save me lots of time..

Kevin Anderson

[e-mail]

PS Thanks in advance
=========================================================================
Date:         Mon, 25 Oct 1993 16:04:19 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Mark=[e-mail]
Subject:      Re: C Interface

Kevin Anderson <[e-mail]> Wrote:
|
|
| Has anyone used or know of a C language interface to Access?
|
| If no direct interface, can C call a VB subroutine that in
| turn access the data.
|
| I have a system in C, that I want to port to Access. The
| system
| has a lot of complicated reports that I feel I probably may
| not be able to duplicate in Access. I would therefore like to
| keep the C reports and simply replace to existing IO calls
| with
| calls to ACCESS directly (or thru VB)
|
| ?????
|
| Any thoughts would be greatly appreciated..and save me lots
| of time..
|
| Kevin Anderson
|
| [e-mail]
|
| PS Thanks in advance

Well one idea that I used in a similar situation, was to use the DDE
capabilities of Windows and Access.  Worked out okay for me, but may not
in your case.

Mark Wignall
=========================================================================
Date:         Mon, 25 Oct 1993 15:42:02 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Mark=[e-mail]
Subject:      Re: Appending Records

Sam Somuah <[e-mail]> Wrote:
|
|
| HELP!
| I am new to Access and I have problems implementing some of
| the features
| that I can accomplish easily in Clipper. This is the situation
| I have an Access form that is based on a Table with fields
| such as
|
| Field 1: aa
| Field 2: bb
| Field 3: cc
|
| Once the form is completely filled Access appends the new
| record to the
| fisrt table. I would however like to append the same record
| to a second
| table. I tried an append query but it picks up all the
| records in the first
| table where the value in field aa equals the value in field
| aa on the form
| and appends it to the second table so that I end up with
| sometimes five new
| records in the second table.
| How do I get access to append only the new data entered on
| the form to the
| second table
|
|
| In Clipper the code will be like this
| select A
| append several fields to the first table
| Select b
| append the same fields to the second table
|
| Any help from some expert will be great since I'm out of my
| wits.

I would do it like this:

1.  Using an Access Basic Function that is called when the Button on the
    form is pressed that looks like:

    Function foobar()
    Dim db as Database
    Dim A as Table, B as Table, f as Form

    set db=CurrentDB()
    set a=db."Table A's name"
    set b=db."Table B's name"
    set f = Forms!"Form name"

    a.edit
    a.Field1 = f.FormField1
    a.Field2 = f.FormField2
    a.Field3 = f.FormField3
    a.append

    b.edit
    b.Field1 = f.formField1
    b.field2 = f.formfield2
    b.field3 = f.formfield3
    b.append

    a.close
    b.close
    End Function

hope this helps.

Mark Wignall
=========================================================================
Date:         Mon, 25 Oct 1993 19:45:29 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: C Interface
In-Reply-To:  <[e-mail]> from "Kevin Anderson" at Oct
              26, 93 08:11:00 am

Kevin,

Get a copy of the Q&E ODBC library.  You can use ODBC to talk to Access.

John - haven't done it, but everyone else says they have!
=========================================================================
Date:         Mon, 25 Oct 1993 19:48:35 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Appending Records
In-Reply-To:  <[e-mail]> from "Sam Somuah" at Oct 25,
              93 09:06:55 pm

You might also be able to accomplish this using an append query that
references the fields on the form and is triggered by the AfterUpdate
property of the form.  Bring the form up, build the query and give it a
try.

John
=========================================================================
Date:         Mon, 25 Oct 1993 19:56:18 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Dynamic allocation of record source property
In-Reply-To:  <[e-mail]> from "[e-mail]" at Oct 25,
              93 09:48:58 am

The approach that has been suggested will work if you do an
OpenQueryDef, assign the SQL to the Query, close the Query and then run
the report with the newly configured query as the record source.

It strikes me that it might be easier to take and hour, merge all the
tables, and insert an extra field to identify the original source of the
data, if that is important.  You then have one, simple report.

John
=========================================================================
Date:         Tue, 26 Oct 1993 07:51:50 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Richard J. Pugh" <[e-mail]>
Subject:      One-to-many relationships in Access

Ladies and Gentlemen,

Hi, I'm new here.

I am using Access 1.1 to construct a bibliographic database of citations
for a library-type application.  Materials include books, journal articles,
electronic documents, technical reports, government documents, and even a
few multi-media works.  My working plan is to set up something like this:

<table: books>                ------|
<table: journal articles>     ------|
<table: e-documents>          ------|
<table: technical reports>    ------|------->    <table: "controller">
<table: govdocs>              ------|
<table: multi-media>          ------|

[add others later if necessary]

The "controller" table would contain data elements common to all the other
tables, such as author and title.  Querries would work mainly with this
table (unless the user is looking for a specific media), which would be
linked to the others either by a direct one-to-many relationship, or
through a calculated field.  My hope is that the user will not be aware
that he/she is searching several tables at the same time.  The records
would be "interfilled" according to the order set by the controller table.

Have I lost anyone yet?  I hope not.  :-)

Have any of you attempted this type of set up?  If so, could you give me
some tips on how to proceed?  Is there anything I should watch out for?
What kind of problems can I expect?

Please respond to me personally.  If others are interested, I will forward
the information.

Thanks in advance.

Richard J. Pugh

------------------------------------------------------------------------------
Richard J. Pugh, Assistant Librarian        |"Traveling Eternity Road,
  Central Tech Services, Cornell University | What will you find there?
  110C Olin Library                         | Carrying your heavy load,
  Ithaca, NY 14853                          | Searching to find, some peace
  Internet:  [e-mail]               |    of mind."  --The Moody Blues
------------------------------------------------------------------------------
=========================================================================
Date:         Tue, 26 Oct 1993 08:19:43 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Thornton Prime <"Thorton_~Prime_at_lmu-acad1"@LMUMAIL.LMU.EDU>
Subject:      Re: C Interface & Other Question

I am interested in writing a small C++ program for windows (or for that matter
DOS) that can read and write to .MDB files.

Is there something like a Class Library for this, or better yet, can I somehow
use the functions built into Access's DLLs?  using DDe is not good enough for
me.  I don't want to have to use the whole client/server thing.  I want to be
able to distribute my C++ program WITHOUT Access, so that someone can do simple
database manipulation through my application without buying MS Access.

Also, I posted a question about changing the User() without exiting Access.  I
didn't see it on the list, so I'll repost it here ...

     I am currently writing an application for Access that
     requires use by different users at the same station.  My
     problem is that I cannot change the User() without closing
     the database, exiting Access and then restarting Access.

     Does anyone know of a way to change the User without exiting
     the database, or at least without having to restart the
     Access Database engine?

Thanks in advance,

Thornton Prime
=========================================================================
Date:         Tue, 26 Oct 1993 10:59:31 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Administrative Note

NOTICE:  This message applies ONLY to those people DIRECTLY subscribed
to ACCESS-L@INDYCMS.

There seem to have been a lot of minor Internet address changes out there
in the past couple of months, which is throwing people off when they try
to CONFIRM ACCESS-L and get a message that they are not subscribed.

If you believe your address may have changed slightly in the not-too-
distant past, please send a QUERY ACCESS-L command to LISTSERV@INDYCMS
and see if it recognizes you.

If your address <has> changed, please let me know by sending PRIVATE mail
to me (please do NOT burden the list with it!) and I will attempt to
sort things out.  Please include the header of the error message so I
can see the routing.

Thanks, Nathan

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Tue, 26 Oct 1993 09:55:45 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Tim King <uswnvg![e-mail]>
Subject:      Re: Jennings' Book
In-Reply-To:  <[e-mail]> from "Phil Paxton" at Oct 25,
              93 12:24:50 pm

Thus spake Phil Paxton:
> "Database Developer's Guide with Visual Basic 3.0"  (0-672-30440-6)

Sounds great. Is it out yet?

--
Tim King, [e-mail]
US West NewVector Group Inc., Bellevue, Washington
=========================================================================
Date:         Tue, 26 Oct 1993 15:54:31 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Re: C Interface & Other Question

% I am interested in writing a small C++ program for windows (or for that matter
% DOS) that can read and write to .MDB files.
%
% Is there something like a Class Library for this, or better yet, can I somehow
% use the functions built into Access's DLLs?  using DDe is not good enough for
% me.  I don't want to have to use the whole client/server thing.  I want to be
% able to distribute my C++ program WITHOUT Access, so that someone can do
 simple
% database manipulation through my application without buying MS Access.

I wouldn't go the DOS route unless you really are just trying
to challenge yourself.  I would suggest, however, that you
look at the ODBC side of things.  I think you'll find what
you are looking for there.

phil

---------------------------------------------------------------------
phil paxton
development editor
sams/prentice hall computer publishing  <=== "GO SAMS" via Compuserve
paramount publishing
indianapolis, indiana
=========================================================================
Date:         Wed, 27 Oct 1993 01:21:21 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Re: C Interface & Other Question

I have much experience working with C++ and object oriented
programming.

Recently I started working in a relational db framework.

Is it bad practice to implement inheritance in tables using
foreign keys into base class tables to represent inheriteance.

I would also like to use inheritance in forms so that I could
use the form for a "person" as a subform in a table for "plumbers"
as well as using it in a form for entering "electricians".
It takes 10 seconds to load the derived class forms.  Should I abandon
object oriented concepts in the relational framwork?

Alex Jacobson
=========================================================================
Date:         Wed, 27 Oct 1993 10:01:30 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John Bartsch <[e-mail]>
Subject:      Re: ACCESS-L Digest - 25 Oct 1993 to 26 Oct 1993
In-Reply-To:  <[e-mail]> from "Automatic digest
              processor" at Oct 26, 93 11:00:06 pm

Please unsubscribe me.
--
John G. Bartsch                   | UUCP:   uupsi!monymsys!monygmc!johnb
MONY Financial Services, MD 75-14 | Domain: [e-mail]
Glenpointe Center West            |
Teaneck, NJ 07666-6888            | Phone [phone]   Pager: 201-612-4211
=========================================================================
Date:         Wed, 27 Oct 1993 08:36:14 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dave Finley <[e-mail]>
Subject:      MS dumping Access Progamming?

I recently received the latest "Infoworld". In Cringley's column, he states
that, at the rollout for the new version of MS-Office, Bill Gates
supposedly said that _FOXPRO_ would be the DB Developer's system. Further,
he is said to have hinted that programming (i.e., "Access Basic") will be
removed from future versions of MS-Access.

Admittedly, Cringley is the "Gossip" columnist for Infoworld. He often
deals in rumors. But, even if it "might" be true, it is of concern to us in
the Access community. From the postings on ACCESS-L, most of us are doing
_SERIOUS_ development in ACCESS. Anything that threatens our ability to
do serious development in Access is a MAJOR THREAT!!!!  And something we
need to take _SERIOUSLY_!!!!!!!!

What do you all think?


Dave Finley

[e-mail]
=========================================================================
Date:         Wed, 27 Oct 1993 13:48:30 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: MS dumping Access Progamming?
In-Reply-To:  <[e-mail]> from "Dave Finley" at Oct 27,
              93 08:36:14 am

Dave,

This is a topic that has gotten serious discussion on Compuserve.  The
gist of Gates comment was that Access BASIC, as a language was going to
be merged with Visual BASIC, so in that sense it would be gone.  Several
persons stated that they had heard Gates speak, and that Cringely had
badly quoted him out of context.  Maybe it's his breakup with Pammy.

Happy coding.

John
=========================================================================
Date:         Wed, 27 Oct 1993 15:43:43 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: MS dumping Access Progamming?
In-Reply-To:  Message of Wed, 27 Oct 1993 08:36:14 EDT from <[e-mail]>

Since I read some time ago (don't remember where) that MS was going to
harmonize all of its macro languages into one "basic" that would remain
constant between its applications--and since Access Basic was said to be
the base platform for that, or at least highly important in that vein--
I somehow doubt the veracity of that rumor.  Access would certainly lose
my support without AB.

Supposedly Access Basic, WordBasic, and the Excel macro language are
going to be so similar in the future that it won't matter much which
application you're working in--you'll still be able to write extensions
to please yourself.  I cautiously give this a "hurray!" but I'll wait
to see it before I cheer too much.

Oh, and hello Microsoft--I'd STILL like to see more of the Access
navigation functions in VB!!!!!!

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 27 Oct 1993 16:43:26 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      ObUL: MS dumping Access Progamming?

% I recently received the latest "Infoworld". In Cringley's column, he states
% that, at the rollout for the new version of MS-Office, Bill Gates
% supposedly said that _FOXPRO_ would be the DB Developer's system. Further,
% he is said to have hinted that programming (i.e., "Access Basic") will be
% removed from future versions of MS-Access.

% Admittedly, Cringley is the "Gossip" columnist for Infoworld. He often
% deals in rumors. But, even if it "might" be true, it is of concern to us in
% the Access community. From the postings on ACCESS-L, most of us are doing
% _SERIOUS_ development in ACCESS. Anything that threatens our ability to
% do serious development in Access is a MAJOR THREAT!!!!  And something we
% need to take _SERIOUSLY_!!!!!!!!

% What do you all think?

(see my alteration to the subject line)

Based upon your "tone" (see capitalization), I think you're overreacting.
Yes, it would be a threat but I really, really doubt it will happen.

If Access were such a disposable product, it would not receive the attention
it has already received and Microsoft wouldn't worry about such things
as not adding it to Microsoft Office in order to keep the unit sales
numbers separate from bundles.

Without ABC, Access would then approach toys like Approach (Lotus).
Don't get me wrong -- Approach is nice for those who need nice,
simple, turnkey databases but hardly the powerhouse we see in
Access.

Finally, I think it's rather comical to see such info from Cringely
since the same thing was basically said about FoxPro several times
in the last year -- it was being absorbed into Access, blah-blah-blah,
which was taken quite seriously when the rumours Rushmore would be
incorporated into a future release of Access.  Bill(y the Kid) reassured
FoxPro fans [that] FoxPro isn't going away.



Dave Finley

[e-mail]
=========================================================================
Date:         Wed, 27 Oct 1993 14:04:11 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Mark=[e-mail]
Subject:      Re: MS dumping Access Progamming?

Dave Finley <[e-mail]> Wrote:
|
|
| I recently received the latest "Infoworld". In Cringley's
| column, he states
| that, at the rollout for the new version of MS-Office, Bill
| Gates
| supposedly said that _FOXPRO_ would be the DB Developer's
| system. Further,
| he is said to have hinted that programming (i.e., "Access
| Basic") will be
| removed from future versions of MS-Access.
|

...Some stuff deleted

|
| What do you all think?
|
|
| Dave Finley
|
| [e-mail]

Well, I would take it all with a grain of salt.  I mean, Microsoft has
never taken something out of their product (to my knowledge).  Combine
this with the fact that Microsoft plans to Alter the Macroing capabilities
of Excel, Word and make them more like Visual Basic, and or Access.  This
comes about in their concept using the new OLE 2.0 standard.  In it,
certain applications have certain capabilities.  If one application needs
another's capabilities, it just OLE's them and uses it.  With that in
mind, and their intent of coming out with this 'Macro language for all'
idea, I find it hard to believe that it would be 'GONE' ... more likely
altered.

Just my $.02 worth

Mark Wignall
=========================================================================
Date:         Wed, 27 Oct 1993 13:01:01 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: MS dumping Access Progamming?
In-Reply-To:  <[e-mail]>; from "Dave Finley" at Oct
              27, 93 8:36 am

> I recently received the latest "Infoworld". In Cringley's column, he states
> that, at the rollout for the new version of MS-Office, Bill Gates
> supposedly said that _FOXPRO_ would be the DB Developer's system. Further,
> he is said to have hinted that programming (i.e., "Access Basic") will be
> removed from future versions of MS-Access.
>
> Admittedly, Cringley is the "Gossip" columnist for Infoworld. He often
> deals in rumors. But, even if it "might" be true, it is of concern to us in
> the Access community. From the postings on ACCESS-L, most of us are doing
> _SERIOUS_ development in ACCESS. Anything that threatens our ability to
> do serious development in Access is a MAJOR THREAT!!!!  And something we
> need to take _SERIOUSLY_!!!!!!!!
>
> What do you all think?
>

I think that this "rumor" is wrong.

The last time I saw
Bill speak (at DB/EXPO in San Fransisco this year), all indications (from
Bill and the tech support people at the Microsoft booth) were that all of
their products will be interchangable someday. You'll even buy them as
separate modules. An applications development environment (like in FoxPro,
VB or Access), will be bought separate from a language (Basic, FoxBase, C++),
and separate from a database engine (just about anything), and they will all
work together. In other words, take the interface builder from VB, the
reports from Access, C++, and SQL server, and you have a development
environment. Or, whatever other combo you want. _That_ is where MS was
indicating they were heading. And, in the past, every MS person I have
spoken to has indicated that FoxPro would eventually merge with Access. The
end product might be one or the other, or a new product entirely. But they
_are_ dedicated to making sure everyone has a clean path, with no loss of
compatability. Go ahead and call someone at MS, and they will at least tell
you this much.

One way or another no-one is going to lose anything by using Access.

--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Wed, 27 Oct 1993 09:31:00 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Long <mvgsd![e-mail]>
Subject:      Rounding numbers

I'm working with a report that shows numerical data
along with a graph of that same data.

I obtain the numerical data from a query and round those numbers to
the first decimal point using the format command for the text
box.
However, the graph data is taken directly from the query and
I don't see how round the numbers to the same values!
So..I have numerical data, and a graph of that same data...
and THE TWO DON'T MATCH. AHH!
I'm guaranteed that people will see the difference and raise
hell.
Any solution too this problem?

Much appreciation
==============================================================================
  David B. Long                             E-Mail=> [e-mail]
  AT&T Network Systems (N.Andover MA.)      or=> [e-mail]
  Quality Engineering                       Tele=> 508-960-3683
==============================================================================
=========================================================================
Date:         Thu, 28 Oct 1993 16:07:24 EET
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Petteri Karna <[e-mail]>
Organization: University of Helsinki
Subject:      DSum problem:"Domain" more than one table

Hello to all Access users,
I would appreciate if anyone of you could help in the following
problem: I have an expression in my module
x=DSum("[a1]","Payments","[[checkfield]="YYY"")

I would like to have a sum of a1 field from Payments table, but the
criteria field (checkfield) is from different table. Is it possible to
have 2 tables as the domain (now there is only "Payments") or is it
possible to use SQL statements in expression/domain/criteria. At
least the manuals/Access KB do not give any examples of SQL statements
in DSum function.

All hints greatly appreciated,

Petteri Karna
=========================================================================
Date:         Thu, 28 Oct 1993 07:54:31 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Rounding numbers
In-Reply-To:  <[e-mail]> from "David Long" at Oct 27,
              93 09:31:00 am

David,

Use a calculated field in the query to format the query results.  If you
field name is douLotsOfDecimalPlaces, and the table name is
tblLotsOfData, the calculated field would be TwoDecimalPlaces:
Format(tblLotsOfData![douLotsOfDecimalPlaces], "#0.00").  That should do
the trick.

John
=========================================================================
Date:         Thu, 28 Oct 1993 07:57:34 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: DSum problem:"Domain" more than one table
In-Reply-To:  <[e-mail]> from "Petteri Karna" at Oct 28,
              93 04:07:24 pm

Petteri,

Create a query that contains all of the data you need, including the
checkbox.  Use that query as the input for the second query that does
the DSum.

John
=========================================================================
Date:         Thu, 28 Oct 1993 08:20:50 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         M Kingsley <[e-mail]>
Subject:      Configuring MSAccess for multiuser operation on a Netware LAN

We're about to install our first Access product for about 6-12 LAN users under
Netware 3.1 and we're getting differering opinions on how to configure. Our
product must support full restoration for transaction processing; so our data
base will reside on a SUnix server running Oracle 6. An upgrade to Oracle ver.7
is scheduled in the not-to-distant future. An ODBC connection between Access
and the DataBase server has been established.


The two opinions we've gotten fall on either side of the issue of whether to
run Access separately from each client's C: drive.  This would mean duplicating
a single .mdb for each client or user.  Despite the obvious hassle, sources
close to Microsoft have recommended this solution.

Alternatively, we could store a single Access .mdb on the LAN server and link
it to an icon for each user. This is mentioned as a feasible alternative in the
MSAccess Users' manual (Appendix D) and would appear to offer the simplest,
most direct solution.

Any responses, especially based on experience (bitter or otherwise) would be
most welcome...............Monty
=========================================================================
Date:         Thu, 28 Oct 1993 14:07:28 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jim Dantin <[e-mail]>
Subject:      Running Totals

I'm looking for ideas to solve the following problem:

Data table contains date and a number.  I'd like to create a query that
would locate the data of the maximum 3-day running total:

Jan1=Dec30+Dec31+Jan1
Jan2=Dec31+Jan1+Jan2
Jan3=Jan1+Jan2+Jan3
etc.

The data covers 10+ years.  I'd like to know the date and the 3-day total.
=========================================================================
Date:         Thu, 28 Oct 1993 12:58:36 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Tim King <uswnvg![e-mail]>
Subject:      Re: MS dumping Access Progamming?
In-Reply-To:  <[e-mail]> from "Dave Finley" at Oct 27,
              93 08:36:14 am

Thus spake Dave Finley:
>
> I recently received the latest "Infoworld". In Cringley's column, he states
> that, at the rollout for the new version of MS-Office, Bill Gates
> supposedly said that _FOXPRO_ would be the DB Developer's system. Further,
> he is said to have hinted that programming (i.e., "Access Basic") will be
> removed from future versions of MS-Access.

Everything that I've read, including press releases from Microsoft,
indicates that Access Basic will be going away and will be replaced by
Visual Basic Applications Edition, a superset of today's Access Basic.
Current AB code will be compatible.  Either Cringley misquoted, or he is
being overy influenced by Erica, a well known Fox(pro) developer.

--
Tim King, [e-mail]
US West NewVector Group Inc., Bellevue, Washington
=========================================================================
Date:         Thu, 28 Oct 1993 13:22:48 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Ron Apland <[e-mail]>
Subject:      Re: multiple break points in reports-subtotals

I have a query off a couple of linked tables I would like to display in a
report.  What I would like to be able to do is group on one field, subtotal
on another field for elements in another field (no problem yet) but subtotal
on two more fields within a restricted range of that third field.  Seems like
a where clause in the function in the report should do the trick except
ACCESS (at least v1 that I have) won't allow it.  Here is how I would like
the report to look.

field1          field2          field3          field4          field5
(grouped)       (sorted)        (calculated)    (calculated)    (calculated)
A1              A2              A3              A4              A5
                A2              B3              B4              B5
                B2              C3              C4              C5
                B2              D3              D4              D5
                                                subtotal        subtotal
                C2              E3              E4              E5
                C2              F3              F4              F5
                                subtotal

B2              A2              A3              A4              A5
                ...             ...             ...             ...

Field3 would be summed over A3-F3 in association with A2-C2 whereas field4
would be summed only over A4-D4 in association with A2-B2 as would field5.
I would also like to display the values and their subtotals as shown.

Ron
=========================================================================
Date:         Thu, 28 Oct 1993 12:36:08 PDT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: Configuring MSAccess for multiuser operation on a Netware LAN
In-Reply-To:  <[e-mail]>; from "M Kingsley" at Oct
              28, 93 8:20 am

> The two opinions we've gotten fall on either side of the issue of whether to
> run Access separately from each client's C: drive.  This would mean duplicatin
g
> a single .mdb for each client or user.  Despite the obvious hassle, sources
> close to Microsoft have recommended this solution.
>
> Alternatively, we could store a single Access .mdb on the LAN server and link
> it to an icon for each user. This is mentioned as a feasible alternative in th
e
> MSAccess Users' manual (Appendix D) and would appear to offer the simplest,
> most direct solution.
>
> Any responses, especially based on experience (bitter or otherwise) would be
> most welcome...............Monty


Monty,

I use the single .MDB approach. My environment is such that a number of
continuous enhancements are made to the application, so it is much easier
to simply to modify or replace the single .MDB than to distribute a new
version of it every time I make an update!

Something else: while you aren't putting your data in Access, for those
who do, I've found that the single .MDB approach also works better. When
installing multiple .MDB's for the interface, each Attaching the tables
from a single .MDB holding the data on the network, each client's
performance seems to suffer. Logic should dictate that having the forms
and such locally would speed things up, but it must have something to do
with the way Access "attaches" tables. Attached tables from .MDB files
are accessed less efficiently than just opening up the .MDB directly, network
or not.

--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Fri, 29 Oct 1993 11:52:04 GMT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Richard Saunders,
              Computer Centre" <[e-mail]>
Organization: University Of East London
Subject:      Re: Running Totals

> I'm looking for ideas to solve the following problem:
>
> Data table contains date and a number.  I'd like to create a query that
> would locate the data of the maximum 3-day running total:
>
> Jan1=Dec30+Dec31+Jan1
> Jan2=Dec31+Jan1+Jan2
> Jan3=Jan1+Jan2+Jan3
> etc.
>
> The data covers 10+ years.  I'd like to know the date and the 3-day total.
>
Presumably you'd like ALL the dates if the maximum total occurs more
than once, as seems very likely. The best I can come up with is as
follows - I'm sure it can be improved on by anyone with a bit more
experience of Access than me. For example, if your dates are in
unbroken sequence possibly there's a way to avoid using the DateAdd
function altogether. Anyway, here goes.

Create a new query (QUERY1) and turn on View Table Names.

Add your table to the query 3 times. If the original table is called
TABLE1, the next two will automatically be called TABLE1_1 and
TABLE1_2.

Add the date and number from each table to the QBE grid.

Set the criteria for Date in Table1_1 to
DateAdd("d",-1,[Table1].[Date])

Set the criteria for Date in Table1_2 to
DateAdd("d",-2,[Table1].[Date])

In a blank column create the following expression (Expr1)
[Table1].[Number] + [Table1_1].[Number] + [Table1_2].[Number]

This query will give all the 3 day totals, and will automatically
start at the 3rd date in the table.

Create QUERY2 based on QUERY1.
Click TOTALS tool.
Drag Expr1 to the QBE grid.
Set its Totals box to Max.

This query gives the maximum value.

Create QUERY3 based on QUERY1.
Drag Table1.Date and Expr1 to the grid.
Set the criteria for Expr1 to the number you got from QUERY2.

I'm sure this last bit can be improved on!
=========================================================================
Date:         Fri, 29 Oct 1993 14:26:26 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Sheryl Smoot <[e-mail]>
Subject:      Unions in Access

     Hello-

     I have a function in a application that we are developing that needs
     to build a query out of two tables that are NOT related.  Basically
     what I would like to do is append the results of one query to the end
     of another (I believe this can be done using a UNION in SQL 92).

     The suggestions I have gotten so far have all involved building a new
     table (for the number of times the users will want to perform this
     function - I'd prefer not to have to go this route).  Is there a
     different way I could do this that anyone has discovered?

     TIA!

     Sherry Smoot
     *****************************************
     [e-mail]
     American Management Systems, Inc.
=========================================================================
Date:         Fri, 29 Oct 1993 13:05:46 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Unions in Access
In-Reply-To:  <[e-mail]> from "Sheryl Smoot" at Oct 29,
              93 02:26:26 pm

Sheryl,

I just checked the current version of the Access knowledge base, and
making a table is the only way to do a union.  Maybe in the next
version.

John
=========================================================================
Date:         Fri, 29 Oct 1993 09:31:16 PDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jim Renaud <[e-mail]>
Subject:      Re: Configuring MSAccess for multiuser operation on a Netware LAN

I also use the single .mdb approach because of the ease in distributing
updated versions. However that same reason dictated that I attach all
the tables such that I now have one .mdb with all the data (tables)
and another .mdb with the code (AB, Queries, Forms, Reports). This was
the only way I could easily upgrade the customer (just copy in the
new version of the code .mdb over the old .mdb) without messing with
the existing data in the data .mdb.

Although I did take a performance hit with attached tables, I did it
early on so the customer did not know any better. The customer does
not complain about performance, even with this running on a WFW network.
Although, each machine is a 486DX-33 with plenty of RAM. With WFW 3.11
coming out, I am hopeful that I will get even more performance out of
the network.


>
>
> Monty,
>
> I use the single .MDB approach. My environment is such that a number of
> continuous enhancements are made to the application, so it is much easier
> to simply to modify or replace the single .MDB than to distribute a new
> version of it every time I make an update!
>
> Something else: while you aren't putting your data in Access, for those
> who do, I've found that the single .MDB approach also works better. When
> installing multiple .MDB's for the interface, each Attaching the tables
> from a single .MDB holding the data on the network, each client's
> performance seems to suffer. Logic should dictate that having the forms
> and such locally would speed things up, but it must have something to do
> with the way Access "attaches" tables. Attached tables from .MDB files
> are accessed less efficiently than just opening up the .MDB directly, network
> or not.
>
> --
> Tony Hamilton                 |
> -Intel Corporation            | voice: 916-356-3070
> --Folsom Engineering Services | mailstop: FM2-55
> ---Engineering Resource Group | email: [e-mail]
> ----Software Technician       |
>



-----------------------------------------------------------------------

Jim Renaud                              [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 235                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470
=========================================================================
Date:         Sun, 31 Oct 1993 15:45:17 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         DARRYL BRAATEN <[e-mail]>
Subject:      Apt numbers

In designing a data base for aptment maintence records we have come
across a small problem.  In this particular apartment the numbering
system is not very consistant  the numbers go like this 1,2,3,4a,4b,5,6
if a alpha field is used to store the numbers apartment 4a will come
after apt. 40 when it should come after 3.  has anybody come up with a
solution to this problem before?  It has to be a fairly common problem.

Any help would be very welcome.
replies can be sent to [e-mail] or reply in the list I read
it every day (just about any way).
ttfn
Darryl Braaten